Forum Discussion

chrismpbi's avatar
chrismpbi
Frequent Visitor
8 years ago

Split average of sum between start and end date

Hi,   I would like to calculate the average of a sum and split it between the start and end date. Hope somebody can help me with this. Chris    
Need Help
jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

There's a few posts on how to do this, but a bit more info would be useful - are you just splitting it by months? Does it matter how much of a month a project is running for? What were you doing in May?

  • chrismpbi's avatar
    chrismpbi
    Frequent Visitor
    8 years ago

    Hi Jthomson,

     

    This is just an example dataset. I have a few thousand lines with project costs. I would like to split those costs over the project duration. It would be good if I could also split it per day but its not necessary.

     

    Christoph