Forum Discussion

Brookied's avatar
Brookied
Helper I
5 years ago
Solved

Summerize project Budget spanning years?

Hi Guys,  Having a mare with this one and just cannot get to work.     I have a table of data where each project has allocated budget value. this in turn will be used between two dates (10-12-2018...
Need Help
Show and Tell
Tutorial Requests
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

How did you arrive at the figures in the last table of your original post.  Between 10/12/2018 and 31/3/2023, there are 1,573 days.  Between 10/12/2018 and 31/12/2018, there are 22 days.  The proportionate agreement value to be booked in 2018 should be 14,102,475/1,573*22 = 197,237.41.  How did you arrive at 271,201.44 for 2018?