Using Parameters and Aggregates within Conditional Expressions

Before you can use a parameter in a conditional expression, you must add the parameter using the Parameters tab (see Adding New Parameters).

Parameter names that contain only letters and numbers (and do not start with a number) can be typed in directly. Other parameter names must be surrounded by single quotation marks. If the parameter name contains a single-quote character, double it (e.g., 'Don''t').

Members of aggregate parameters can be referenced using dot notation: agg.member. Aggregates and arrays can be combined: agg.arr[i, j].

When referencing a member of an aggregate where the aggregate parameter name or the member name contains punctuation, you can put single quotation marks around the entire name (e.g., 'agg with space.mem with space') or separately around each portion (e.g., 'agg with space'.'mem with space').

Parameters and functions can have the same name because function names are followed by an open parentheses, and parameter names are not.