Variables and other dollar-sign expansions can be used in set expressions.
Examples:
| Example | Result |
|---|---|
| sum( {$<Year = {$(#vLastYear)}>} Sales ) |
Returns the sales for the previous year in relation to current selection. Here, a variable vLastYear containing the relevant year is used in a dollar-sign expansion. |
| sum( {$<Year = {$(#=Only(Year)-1)}>} Sales ) |
Returns the sales for the previous year in relation to current selection. Here, a dollar-sign expansion is used to calculate previous year. |
