Skip to main content

Hello, is there a best practice to rebalance forecasts to hold to the beginning of the quarter’s forecast.

 

For example, if on Jan 1st, I forecast to spend $12k for Q1 ($4k per month) and then when I get to Feb 1st, I actually spent $6k in January. I now manually take $12k - $6k = $6k / 2  =  $3k, and then I forecast $3k for each February and March each to hold the $12k for the entire Q1 forecast + Actuals.  

 

Is there an automated way (not manually doing the math and re-entering for the remaining months) to do this?

@Bryan Bauer Can you try the formula below?

ifblank(
        IfBLANK('01. Actual',(('02. FCST'.BY:Month.Quarter]-'01. Actual'ABY:Month.Quarter])/(3-'01. Actual'Aby count:Month.Quarter]))rby:Month.Quarter])
        ,'02. FCST'
        )


'01. Actual' is your metric for actual, while '02. FCST' is your forecast metric.


Reply