totals in a defined period, how to make the formula?

[chriscools]

Hello,

i need to make totals for invoiced quantities per article, but in a defined period.

there is a datefield for the invoices, but how do i incorporate it in my formula so that i have only the invoice quantities from 1/1/2012 untill 30/6/2012?

my formula is: sum ( InvoiceQty)  and the date field is called "DATE" ( who would have guessed... 🙂 )

can someone give me a clue?

thank you very much!

grtz,

chris

[fosuzuki · Accepted solution]

maybe: sum({<DATE={">=1/1/2012<=30/6/2012"}>} InvoiceQty)

the article woul be the dimension of your chart.

Hope this helps

Fernando

[chriscools]

Hello Fernando,

thanx, this seems to work ok!

grtz,

chris