+1Hi Team, I have an existing formula for moving average, however I want to add another condition that if the moving average is negative, then the result should be zero.
This is my formula right now:
IF(Actual?,MOVINGAVERAGE('Actual',3),PREVIOUS('Month))
Can you help me how can I add my new condition in this formula? Thank you!
+8Hi Suzzy,
If you don’t want to see the value less than 0, You can add this FILTER at the end of the equation :
IF(Actual?,MOVINGAVERAGE('Actual',3),PREVIOUS('Month))[FILTER : CURRENTVALUE >= 0]
This will filter out all values less or equal to 0.
If you want the values to be 0 instead of blank:
IFBLANK(IF(Actual?,MOVINGAVERAGE('Actual',3),PREVIOUS('Month))[FILTER : CURRENTVALUE >= 0],0)
Let me know if this works for you!
Best,
Seth
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
