4 Replies Latest reply: Nov 23, 2010 7:45 AM by Gareth Joubert RSS

    Sum of date range



      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