Forum Discussion
Calculated Run Rate Budget vs Actual diff.
see attached
This doesn't calculate the average of the difference of actual difference between actual and budget and calculate the run rate based on that.
In the screenshot of the excel spreadsheet.
Calculated run rate 2 is correct, but I want the accumulated total in the column "Result".
you lost me at
the average of the difference of actual difference between actual and budget and calculate the run rate based on that.Can you walk me through the required steps?
Yes I'll try my best.
In this table, the matrix called avg. daily run rate, is the difference between realised and budget figures. From the 20th of February, I need to calculate the average of all the days, that hasn't any revenue. Which is from the 1st of February until the 19th of February. Which gives 165 in average.
That average amount needs to be split evenly on the remaining days per day.
So when we have the 20th of February, with a budget on 940, we need to subtract 165 on that day. So it gives 940 - 165 = 775 and so forth.
After this, I would like to have the figures as a running total.
So all in all.
1st of Februray -> 19th of February = Realisered figures.
20th of February -> 28th of February = Budget figures subtracted by the average amount.
Did that make sense?
don't ask me if this makes sense but here's my version.
Hello Ibendlin,
In the sample it works perfectly, I'll let you know, if I get it to work in my production database! Thanks for this.
Best regards
Jonas