How to create formula for YTD and YTG run rate (Moving average)
I would like to create formula to calculate moving average for YTD and YTG. Here's the formula i input MOVINGSUM(Actual, -11, 0, AVERAGE) to calcuate YTD run rate, MOVINGSUM(Remaining, -11, 0, AVERAGE) to calculate YTG run rate but the it doesn't seem correct to calculate the moving average.
In your formula you are hardcoding the numbers and taking the average of 11 months. I would say make that dynamic and check how many periods are there in YTD actuals and how many are there in YTG actuals. (Also Use Actuals in both the line items - though I am not sure what the exact ask is). However you can still do below
Use that dynamic number in your formula
MOVINGSUM(Actual, -11, 0, AVERAGE)
MOVINGSUM(Remaining, -11, 0, AVERAGE)
Alternately I see you are already pulling the values by using SELECT YTD or SELECT YTG, if you do this way then you can just divide that number by the number of counts.