How to sum values past

[#1]

Hello.

I was wondering, whats the proper format of the expressión, in order to Sum only the values previuos from today.

for Example, i got all the planned values of the year. How can i only sum those that are previuos from today?

Any ideas?

Do i make myself clear?

thanks,

[#2 · Accepted solution]

Hi,

Assuming you have 1 straight table with DateField and PlannedValue (and eventually other fields): some possibilities

Sum(if(DateField<Today(), PlannedValue))

Or

-Sum((DateField<Today())*PlannedValue)

There are several other ways. If it doesn't work, please post some sample data.

Hope this helps.

[maxgro]

or with set analysis

sum({$ <Date={"<$(=floor(Today()))"}>} PlannedValue )

[ashwanin]

sum({<date={">=$(=AddMonths(Max(date-6),0))<=$(=Max(date))"}>} Values)