Set Analysis Doubt

[rcandeo]

I need to calculate the sum of my sales quantity since january to the actual month(-1).

In above expression I have the result to the actual month-1:

sum( {$<Month = {$(#=Only(Month)-1)}>} Quantity_Item)

I´ve tried the next expression but i´ve got the sum of the actual month + actual month(-1):

sum( {$<Month < {$(#=Only(Month)-1)}>} Quantity_Item)

How I´ve got the sum of all months till actual month (-1)?

[rcandeo]

I am almost there. Using the expression above, I've got the number I need for this month, but I need to use (month) instead of 6.

sum( {$<Month = {">0<6"}>} Quantity_Item)

Anyone can help me?

[#3 · Accepted solution]

Try this:

=sum( {$<Month = {">0<$(#=Month(Now()))"}>} Quantity_Item)