This content has been marked as final. Show 6 replies
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.