Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I need to display the value of the last month and only the last month. I used a text field and the following expression:
= 'Last month: ' &
num(sum({<MonthYear ={"$(='>=' & Max(MonthYear))"}>} Sales) )
When there is not period selection, there is the right display but when I selected a period (month, Year, ..) the value changes. How to modify the expression in order to have the same value indepent from the sélections we can made?
Thank you,
William
You can use the set identifier 1 to ignore all user selections:
= 'Last month: ' &
num(sum({1<MonthYear ={"$(='>=' & Max({1} MonthYear))"}>} Sales) )
You can use the set identifier 1 to ignore all user selections:
= 'Last month: ' &
num(sum({1<MonthYear ={"$(='>=' & Max({1} MonthYear))"}>} Sales) )
Thank you swuehl! Your expression works great!
Finally I have found this expression :
sum({1<Date={">=$(=MonthStart(Today(), -2))<=$(=Today())"}>} Sales) and it also works!
Thank you,
Regards,
William