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 year sum(forecast_x) so that it will always show the full year total forecast, even if it is only halfway through the year. 

 

I need to do the same for FY Total.  I have tried the following which of course doesn't work and am simply stuck without a solution.

 

calculate(sum(forecast)x), filter(table, date=currentFY))

 

Any help is greatly appreciated. 

Need Help

6 Replies

    • 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