3 Replies Latest reply on Apr 15, 2013 1:57 PM by Jonathan Drummey

    Calculated Field Grand Totals displaying incorrectly

    Brian Cronin

      Hello,

       

      I've tried finding an old post that helps me out but nothing is fitting the bill.  Below is a screenshot.  Basically we're trying to see what the spend difference (Qty times * Current EA or Recalculated EA) is.  It is working correctly on the line level in the table, but when I try to see if it is an overall net spend increase by using a grand total it is displaying a very inflated total, and not the actual sum of the rows for that column.

       

      It's an excel table for the EA columns joined against purchase data out of an ODBC connection.  The relationship is working, but I cannot get the totals to uninflate for the life of me.