Set modifiers with dollar-sign expansions

Variables and other dollar-sign expansions can be used in set expressions.

Examples and results:  

Examples Results
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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?