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.
Hmm not too sure. As this is average you want to exclude the line items from the possible data set. I can only think of this via a filter which is set analysis. However would be interested to be informed otherwise.