3 Replies Latest reply on Sep 27, 2017 8:46 AM by Jim Dehner

    Need help with Total Calculation


      Hi all,


      I´m having a hard time to find a way how to use grand total value of the column Difference and reuse on a calculated field.

      At the end what I need is to reuse Total Difference that is showed on Table and * NoofMalls



      Total on [Difference] is -3841 and on on sheet (Total*NoofMalls) using Fixed I can have the same value -3841.


      But the problem is when I add on Filter All Places the value is slightly diferent.

      Column Difference is showing -2765. Sheet (Total*NoofMalls)  is showing -2768?



      What am I doing wrong ?


      Thanks in advance