4 Replies Latest reply: Jul 2, 2013 10:24 AM by Ravi Hulasi RSS

    Set Analysis - Dates greater than a given number of days ago

      Hi,

       

      I'm running into a problem creating a set analysis using Today() and a user-specified variable.  I'd like the user to be able to interactively set a number of days and have the total cost of sales between that many days ago and today be summed i.e. sum all the sales from 10 days ago up until now.  So far I've come up with the following expression but it always yields zero:

      =Sum({$<SalesDate={">=$(Date(Today()-$(vDays)))"}>}Cost)

       

      Can anyone help point out the error in my expression?

      Thanks,

      Rav