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

    Calculate projected  FYTD not adding correctly

    Geneth McAlister

      Hi,

       

      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: