Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Interesting Links
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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