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

    totalling positive values and negative values

    Sharon Hickox



      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