Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
I expect this to work:
sum({$<[Cost Category]={'Net sales'}, MonthYear={'Jan-$(LastSalesYear)'}>} (1+VAT)*[Monthly amount]/[ActExchRate])
I expect this to work:
sum({$<[Cost Category]={'Net sales'}, MonthYear={'Jan-$(LastSalesYear)'}>} (1+VAT)*[Monthly amount]/[ActExchRate])
Works perfectly.
Thanks Michael