Problem with variable in the Sum Expression

[#1]

Hi, I trying to set several expression which should return the sum of the Amount of the Remaining Invoices (Not yet paid). One for the Current week and the others from the previous weeks. The expression CurrentWeek is like that:

Sum({<CalendarWeek={$(vCurrentWeek)}>} [Remaining Invoices.Amount])

And It works.But when I try to set the sum for the previous weeh (CurrentWeek - 1) it fails

Sum({<CalendarWeek={$(vCurrentWeek-1)}>} [Remaining Invoices.Amount])

What Am I doing wrong ?

Thanks in advance.

[jagan · Accepted solution]

Hi,

Try this

Sum({<CalendarWeek={'$(=(vCurrentWeek-1))'}>} [Remaining Invoices.Amount])

Hope it helps you.

Regards,

Jagan.

[#3]

That's right! thanks a lot!