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

    Need help with Total Calculation

    mafalda.santos

      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

       

      Mafalda