4 Replies Latest reply: May 9, 2018 11:32 PM by Lee Adoremos RSS

    HELP! Can't subtract days from between dates in set analysis

    Lee Adoremos

      Hi All,

       

      I hope you can help me I was stuck on this for quite so many weeks,

       

      I was trying to get the range of Sales using Between in Set Analysis,

       

      Sum({$<Date={">=$(=max(Date)-7)<$(=max(Date))"}>}Sales)

       

      I have Table which looks like this, ideally If I was to get only those Items from 1/24/2008 to 1/17/2008 but it is still aggregating based on the last available date.

       

      Expected Output should be: 4624+480=  5104

      Between.png

      Thanks in advance!