1 2 Previous Next 18 Replies Latest reply on Dec 2, 2019 7:22 PM by Soumitra Godbole

    Grand total not appearing when multiplying two calculated values

    Sameer Sharma

      Hello,

       

      I got stuck with my analysis in finding grand total when multiplying two calculated values.

       

      A little information about my report. I have AMOUNT and VOLUME by month and year. First I Calculated "COST_PER_CASE" by dividing AMOUNT by VOLUME. Then I calculated difference between COST_PER_CASE of current year month vs last year month by using lookup formula (formula mentioned below). After doing this calculation, I wanted to calculate SAVING based on DIFFERENCE X VOLUME of current year. I got the correct result for each month but Grand Total is not coming.

       

       

      Difference Formula : ZN(SUM([COST_PER_CASE])) - LOOKUP(ZN(SUM([COST_PER_CASE]))

       

       

      Any help and/or advice would be highly appreciated.

       

      Thank you,

       

      Sameer

        1 2 Previous Next