Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try this
Sum({<CalendarWeek={'$(=(vCurrentWeek-1))'}>} [Remaining Invoices.Amount])
Hope it helps you.
Regards,
Jagan.
Hi,
Try this
Sum({<CalendarWeek={'$(=(vCurrentWeek-1))'}>} [Remaining Invoices.Amount])
Hope it helps you.
Regards,
Jagan.
That's right! thanks a lot!