Sum of date range

[#1]

Hi

What I am trying to acheive is to sum up the SOTD_QTY_UNITS_ORDERED for the last 3 weeks.

Using these forums I have got to the point below however the formula produces 0 as the value:

Sum( {$< InvoiceDate = {"<$(=date(today(1), 0)>=$(=date(today(1)-21)"}>} sum(SOTD_QTY_UNITS_ORDERED))

Is there something wrong with the formula?

Thanks, Gareth

[#2 · Accepted solution]

Hi Garethj1,

Try the following:

=sum({$<InvoiceDate={'>=$(=date(Today(1)-21,'DD/MM/YYYY')) <$(=date(today(1),'DD/MM/YYYY')) '}>} SOTD_QTY_UNITS_ORDERED)

Regards.

[#3]

Thanks Miguel.

Just one more question on this:

If I needed to replace the Dimension SOTD_QTY_UNITS_ORDERED with the variable " _exp_CASE" how would I write this?

[#4]

Hi,

I don't know what say about this, I would need to know what is the expression into the variable.

Regards.

[#5]

Ah right the penny dropped - Cracked it.

Thanks for all your help, Gareth