Forum Discussion
Calculated Run Rate Budget vs Actual diff.
see attached
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
Hello Ibendlin,
I forgot to say, that the formula should only take into consideration of the current month. Since I want to use it for the future months as well.
I have added some more data in the file, where I added January figures as well, so we have to filter the result of January away - can you fix that, because then you have solved my problem.
So we still get your result from your previous file, but when there is historical data.
Best regards
Jonas
no access