set analysis

[#1]

Hello,

can you help me with this expression plz:

I need to sum the Quantity for which the date is greater than today's date less than one year:

sum({$< DateMVT= {"(>=(date(today()-365)))"}  >} Quantity)

Regards,

Yacine

[swuehl · Accepted solution]

Try

sum({$< DateMVT= {">=$(=date(today()-365)))"}  >} Quantity)

DateMVT format should match the standard date format to make this work.

Instead of subtracting 365 days, you could also use addyears() function.

Hope this helps,

Stefan

[#3]

the final expression :

=sum({$< DateMVT= {">=$(date(AddYears( today(),-1),'DD/MM/YYYY'))"}  >} Quantity)