I am trying to calculate an average score for records while excluding 0's from being included in the average. I don't want to eliminate the record altogether, rather just eliminate the 0's from the average.
Example attached above. The average should be 5 if you remove 0's - i.e. taking the sum (30/6) = 5.
Please advise. Thank you in advance.
Thanks - Unfortunately not having any luck. Fairly new to Alteryx so may be an issue on my end.