4 Replies Latest reply on Mar 9, 2012 7:47 AM by Tracy Rodgers

    How to sum calculated values?  Tried WINDOW_SUM and TOTAL but did not work

    Daniel Carr



      We have records for which we need to:

      (1) Calculate the ABS(SUM([Field])) this is working.  i.e. If we have -400 and 300 then this totals -100.  We want the total to display as +100.

      (2) We want the results of step (1) to be summed.  We have bene unable to get this to work.  We have tried WINDOW_SUM and TOTAL.


      Sample attached.

      Expected totals are:

      Row level:

      ABC - 400

      DEF - 600

      JHK - 450


      Column level:

      EUR - 850

      USD - 600


      Any help greatly appreciated.