2 Replies Latest reply: Nov 15, 2013 4:58 AM by Dagg Stephen RSS

    Set analysis using dates

      I’m trying to use set analysis to calculate the revenue sum for the same day the previous week using the following:

       

      SUM({$<Date={$(=Max(Date)-7)}>} MonetaryValue)

       

      But for some reason, I keep getting zero values returned and I can’t understand why. There is definitely revenue there and it works fine if I hardcode the date within the {}.

       

      Thanks