Forum Discussion
Daily Required Run rate
Solution SageAnonymous Thank you for providing the file, but could you explain how you do the calculations, because I don't understand how the amounts are planned, how you calculate them
DimaMD Yes ,
1.firstly I am getting acheived data Daily
2.and planned data Monthly,so first Query is to convert it to daily
Daily planned spends= monthly planned spends/no of days in month
(e.g. if my planned spends for oct 22 is 300000 so i want to show is daily 9677 (300000/no. of days in month).
3.once that is resolved i want to show daily required runrate formula for that is
no of days left = end of the month day-current day
(if I select 11th of oct so no of days will be 20 i.e. 31st oct -11oct)
Daily runrate =(Daily planned spends-daily acheived spend)/no. of days left
Attatching an image for better understanding
DimaMD No problem ...Achieved spends is spends column in acheived sheet and it corresponds to "spend" column in Planned sheet
- DimaMD
Hi, Anonymous Sorry for the delay, how do you calculate "Archive spend"? and which column corresponds to the amount in the "Planned Data" table?
DimaMD Any luck on this ?
- DimaMD
HI, Anonymous Currently, there are several ideas we are trying to implement.