help with expression

arusanah — Thu, 02 Jul 2015 15:02:35 GMT

I have a variable vFromDate, which i use to calculate current year sales.

i haanother Variable vPYFromDate which i am using to calculate prev years sale

vPYFromDate = 'AddYears(vFromDate,-1)'

i'm trying to write an expression but doesn't work

=SuM({$<TimeLine.Year={$(vPYFromDate)}>}(Fact.CustomerSales*$(=CurrencyField)))

throws error in set modifier

________________________

if i use following expression gives me sale for 2014

what if i want to pic max year from variable vFromDate:

Sum({$<TimeLine.Year={$(=max(TimeLine.Year)-1)}>}(Fact.CustomerSales*$(=CurrencyField)))

how can i modify this to take value from vFromdate

Pls Help

Re: help with expression

MK_QSL — Thu, 02 Jul 2015 15:51:23 GMT

vPYFromDate = AddYears(vFromDate,-1)