How to take Average of Prior Year Values
Hi Anaplan Community,
I am currently using the formula below to take a moving average of my prior year value. So for instance if this formula is in my April 21 month, it is summing April 20 to April 21 and taking the average of that. I want to adjust the formula to look at just the full Prior Year Jan 20 to Dec 20 and apply that average to each month in 21, so basically I want to take out the moving sum piece and just have it be a stagnant prior year sum & average. Any idea how to do this? I tried using the previous function, but couldn't get it to work.. Is there a function I can use to do this or do I need to create an IF THEN statement using my timesettings to get at prior year? Appreciate the help!
MOVINGSUM(value, -12, 0, AVERAGE)