Forum Discussion

DM474's avatar
DM474
Regular Visitor
3 years ago

Sum for Projected Year total

I am sure this is really simple but for some reason I just cannot get this right.    I have a table showing sum(x) for each month, sum(x) YTD, and sum(x) FYTD. Easy.    I need to add the Total ye...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Share some data and show the expected result.

  • DM474's avatar
    DM474
    Regular Visitor
    3 years ago

    See below. The first column shows monthly budget, second is the cumulative budget over the fyear. The third column should always show the EOY budget, ie. 9,341,386.61

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Share the download link of the PBI file.

      • DM474's avatar
        DM474
        Regular Visitor
        3 years ago

        Hi Ashish

         

        I just want help with the generic formula, I cannot share the file. 

         

        It should be a simple formula to calculate the whole year.