A SQL snippet can optionally have parameters to be able to customize the way snippet works for each usage by passing on or more values as parameters.
To define snippet parameters, specify them in the "Params" field and add them in the snippet text with a square bracket notation (i.e. same as if the parameter was a snippet).
To use parameterised snippet in a report, pass it the parameters in brackets (like a function call):
Any parameters that are defined on a snippet but not passed will have a "NULL" value.
An example can be a currency conversion snippet:
WHEN 'EUR' THEN [value] * 1.11
WHEN 'CAD' THEN [value] * 0.76
Usage in report:
SUM([in_usd(account_revenue,account_currency)]) as revenue_in_usd