Data Transformation with average excluding zero
Posted: Wed Sep 13, 2023 3:45 pm
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.
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.