Variable in set analysis expression

[#1]

Hi,

Anyone have an idea why this expression does not work? LastSalesYear standing for last year is variable and this couses problem.

sum({$<[Cost Category]={'Net sales'}, MonthYear={'Jan-' & LastSalesYear}>} (1+VAT)*[Monthly amount]/[ActExchRate])

[Anonymous · Accepted solution]

I expect this to work:

sum({$<[Cost Category]={'Net sales'}, MonthYear={'Jan-$(LastSalesYear)'}>} (1+VAT)*[Monthly amount]/[ActExchRate])

[#3]

Works perfectly.

Thanks Michael