Set Analysis to Sum Values from the day before of the latest Selected

[cristian_av]

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!!

[gmoraleswit]

This blog can be helpful:

Relative Calendar Fields

[maxgro · Accepted solution]

1 day back

sum ({$ <%Date={"$(=date(max(%Date)-1))"}>} ContadorConsumos)

or without date (bold)

[cristian_av]

Thanks!

Altought I was a bit confussed at beginning, because my fieldname is %Date, and you use the date() function.

Finally it started working!