3 Replies Latest reply on Feb 9, 2017 6:56 AM by Jonathan Drummey

    How to make a total of the difference calculation

    Fanni KHARISMA

      Hello

       

      I have some set of data and wanted to get a total of difference calculation based on a logic.

      For example in below table, the difference of Theo SS HS is calculated only if there is a different between PDT and previous PDT.

      At logistic ref level, it seems correct however when I put the grand total, the total of Difference Theo SS HS is not correct.

       

      This is my Grand Total expectation, where in Jan-Mar = 0 and only April I should see the difference.

      However, this works only if I filter the logistic ref and I want to consider all the logistic ref.

       

      Can somebody advice me , how to calculate the difference in grand total ?

      I'm attaching the sample.