0 Replies Latest reply: Aug 29, 2017 10:50 AM by Neil Deeley RSS

    Conditional field in Rangesum

    Neil Deeley

      Hi,

       

      I'm calculating a rangesum which takes in all the dates in my data:

       

      rangesum(

      above(

      (

      (avg(If(Month([BlankDate])='Nov',([Winter Weekly]),

      If(Month([BlankDate])='Dec',([Winter Weekly]),

      If(Month([BlankDate])='Jan',([Winter Weekly]),

      If(Month([BlankDate])='Feb',([Winter Weekly]),

      If(Month([BlankDate])='Mar',([Winter Weekly]),

      If(Month([BlankDate])='Apr',([Low Weekly]),

      If(Month([BlankDate])='May',([Low Weekly]),

      If(Month([BlankDate])='Jun',([Low Weekly]),

      If(Month([BlankDate])='Jul',([Peak Weekly]),

      If(Month([BlankDate])='Aug',([Peak Weekly]),

      If(Month([BlankDate])='Sep',([Low Weekly]),

      If(Month([BlankDate])='Oct',([Low Weekly])))))))))))))

      )

      )

      /7

      ),0,RowNo()

      )

      )

       

      However, I need to constraint the start row of the rangesum to a particular date, in this case the Max([PickupDate]). How and where can I add this into the rangesum?

       

      Thanks in advance!

      Neil