Average without zero values

[Simon4]

Hi all,

I want to calculate the average price. But due to administrational faults the price is not always available. I want to calculate the average price neglecting the zero values to display a more accurate value. Screenshots for more clearity.

Thankyou kindly in advance,

Simon

[rubenmarin · Accepted solution]

Hi, you can add set analysis to remove zero values:

Avg({<NetPurchasePrice={"<0>0"}>} NetPurchasePrice/Quantity)