Data Transformation with average excluding zero

[AJJ]

Hi,
I have a data transformation that performs an average calculation, however the average is diluted by there being lots of zeroes in the data (I can't hide or filter the zeroes because there are several averages we want to display). How can I exclude the zeroes in this average calculation?

Thank you.

[Lech Kulikowski]

Hello,

You can add the custom filter to exclude zeros values.

Thank you.

[AJJ]

This worked really well, thank you.

[Lech Kulikowski]

Hello,

You are welcome.