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