7 Replies Latest reply on May 16, 2018 7:41 AM by Olalekan Agboluaje

    % difference in Grand total Calculation

    Olalekan Agboluaje

      Hi All,


      The % difference in my Grant total view is not working correctly


      The % difference is calculated by (Year 2 sales / Year 1 sale) -1, but for the Grand total, i expect it to do the same calculation but the best i can get it to do is an average which is wrong.

      Basically, i expect the sales movement for the grand total to be calculated as ( 117663 / 126946) - 1


      Thanks for your help