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

    Aggregated/Non Aggregated Date Calculation

    kelly.schmittel

      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

      then

         sum([Selected Measure])

      End