help with expression

[arusanah]

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

pls help!!

[Anonymous]

try

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

Regards!

Jannet.

[alexandros17]

try with

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

[Peter_Cammaert]

Since apparently vPYFromDate contains an expression to evaluate first, you'll have to do just that to get a real date value:

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

although this may not work either as TimeLine.Year may now be compared to a single full date value...