3 Replies Latest reply on Jan 19, 2017 1:56 PM by Joe Oppelt

    Aggregated/Non Aggregated Date Calculation


      I have below formula to calculate Latest 4 week Sales. 'Week End Date' is weekly data not aggregated and 'Min of Dates' is a Min function around a group of dates to return the lowest date so it's aggregated.

      How do I keep the below formula intact but solve the aggregate non aggregate issue? Thanks for the help.


      IF [Week End Date]<=[Min of Dates] and

         datediff('week',[Week End Date],[Min of Dates])<=3


         sum([Selected Measure])