How to Sum excluding dates?

[ecabanas]

Hi,

I have a calendar with a DATEFINANCIAL as a key, with this, I have a calendar slider, etc, but I want to do a calculation excluding the dates, for example:

I selected to see the year 2012 and December, and the sum of units = 100, but I want to knot, how many units has been sold till today=1000

I did this function but it does not works :  Sum({<DATEFINANCIAL= >}  UNITS_INVENT )

Thank's guys!!

[swuehl · Accepted solution]

You need to clear the fields you or your user made the selections in, I am assuming Year and Month:

Sum({<YEAR=, MONTH= >}  UNITS_INVENT )

[er_mohit]

try this

sum({< DATEFINANCIAL = e() >} UNITS_INVENT)

[ecabanas]

thank's!!!! it works!!!!!

Eduard