Forum Discussion
Spreading Project Budget Across Weeks
Hi All, HELP!! I need to take a project budget and work out the weekly burn rate. I have managed to calculate the weekly burn rate, but I cannot work out how to make the weekly burn rate cumulati...
Anonymous , Please refer the approch in blog and file . Both have bit of difference, It is on my data
Try like
Hi Amit,
I am almost there!
I have added an image of the matrix I can currently see.
The problem is that the opportunity sales total is being multiplied by 7 - 8 times.
I reckon this relates to the Crossjoin function but I am not sure how to fix this. Can you help? 🙂
Cheers,
Ashley