Forum Discussion
Daily Required Run rate
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
Hi, Anonymous Sorry for the delay, how do you calculate "Archive spend"? and which column corresponds to the amount in the "Planned Data" table?
- Anonymous3 years agoNot applicable
DimaMD No problem ...Achieved spends is spends column in acheived sheet and it corresponds to "spend" column in Planned sheet
- Anonymous3 years agoNot applicable
DimaMD Any luck on this ?
- DimaMD3 years ago
Solution Sage
HI, Anonymous Currently, there are several ideas we are trying to implement.