Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to make an expression using Set Analysis which Sum the values of the day before of the latest one Selected.
The field is %Date.
An explanation...
I have a field (%Date) wich contains all the possible dates for my data.
I want to do a comparison betweeen the latest day selected and one day back (yesterday), one week back, and so on...
The expression I'm actually using for Today is:
=Sum(ContadorConsumos)
How can I modify the sum to consider N days back of the maxium day selected?
Pseudocode:
=Sum({%Date=%Date-NDays} ContadorConsumos)
Thanks!!
1 day back
sum ({$ <%Date={"$(=date(max(%Date)-1))"}>} ContadorConsumos)
or without date (bold)
This blog can be helpful:
1 day back
sum ({$ <%Date={"$(=date(max(%Date)-1))"}>} ContadorConsumos)
or without date (bold)
Thanks!
Altought I was a bit confussed at beginning, because my fieldname is %Date, and you use the date() function.
Finally it started working!