Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an app where I'm trying to display the sum of sales over the past 3 months
there is 1 table with sales & dates, and 1 table with date values (+ first day of month 3 months ago +last day of last month)
I use the following expression:
" Sum({<Date={">=3MonthsAgo <=LastMonthEnd"}>} Sales) "
but it does not work. When I replace 3MonthsAgo and LastMonthEnd with a random date ("1/1/2017") it does work.
Is my expression wrong?
Maybe like this Sum({<Date={">=$(Monthstart(3MonthsAgo)) <=$(Monthend(LastMonthEnd))"}>} Sales)
Unfortunately that doesn't work either 😕
when the 2 tables are not linked:
when the 2 tables are linked:
the expressions editor shows this:
Can you share the sample app and the output you are expecting?
Hi,
try like below expression
Sum({<Date={">=$(=date(MonthStart(today()-90),'DD/MM/YYYY'))<=$(=date(MonthEnd(today()),'DD/MM/YYYY'))"}>}Sales)
Thanks,
Nitin.