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

      Hello,

       

      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.

       

      Thanks,

      Dan