Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to perform a setAnalysis that would be able to recover 3 months sliding (current month + 2 months previous) of a measurement according to the period dimensioned in the table.
Example: In the example below, here are the CAs for each calendar period:
Imagine the following data:
Period : CA : CA 3 Months Slippery
201803 : 14 280 : 96,081
201802 : 37,634 : 91,801
201801 : 44 167 : 59,167
201712 : 10,000 : etc ...
201711 : 5,000
CA measurement: sum (ca)
CA Measurement 3 Months Slippery:?
Thank you in advance for your help !
Maybe this -
Rangesum(Below(Sum(CA),0,3))
It Works !
I use the Rangeavg in my case in the end.
Thank You so much !
Great! You may close this thread by marking correct answer.