6 Replies Latest reply: Nov 14, 2013 3:32 AM by Ram Asokan RSS

    Removing (-VE) and 0 Sales Amount & Quantity

      Hello there folks,


      I was just wondering - how I can go about removing and 0 values from a report?


      End user has complained that, the and 0 results have been interfering with the average price calculation. They do have a point there, it is no longer accurate.


      I tried this if-statement in the expression, if ( A > 0, A), it only substitutes the amount rows with a dash, but the total sales amount didn't change it remains the same as before the statement was included.


      Please advise. Thanks in advance.


      Best Regards,