2 Replies Latest reply on Jul 7, 2016 7:34 PM by Sharon Hickox

    totalling positive values and negative values

    Sharon Hickox

      All

       

      I'm having trouble trying total negative and positive values to give the total value - eg. -249,599.00 and 1,108.00 give total amount of 250,661 (Fund Name ABCD in attached)

       

      *my data contains negative $ values and positive $ values and need to include a total $ value.

       

      In addition, I have been playing with calculating a Net field and can't quiet get it to work (to show same as Grand Total in attached)

       

      Kind regards

       

      Sharon