2 Replies Latest reply on Sep 13, 2018 3:49 AM by Geneth McAlister

    Calculate projected  FYTD not adding correctly

    Geneth McAlister



      I am calculating a projected monthly figure using the following calculation:

      ([Sales tons incl IDM]/[Max Tot Mtd Sales days])*[Max Tot Month Sales days]


      This is working well (please note that [Sales tons incl IDM] is a calculated measure). (153 350/7)*19 = 364 207


      Unfortunately, it is not working properly for the FYTD.


      The all the figures for the projected are correct but  the Grand Total is not adding them correctly.

      I can't send the packaged workbook unfortunately because it is a massive blended affair.


      By the way, I have tried 'Total Using' but the option is grayed out: