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

    Removing (-VE) and 0 Sales Amount & Quantity

    Ram Asokan

      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,

      Ram