Averaging items from a record while excluding 0's

[kaylagross12]

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.

[Felipe_Ribeir0]

Hi @kaylagross12  

One way of doing this, just replace the input:

[kaylagross12]

Thanks - Unfortunately not having any luck. Fairly new to Alteryx so may be an issue on my end.

[Felipe_Ribeir0]

Hi @kaylagross12 

Could you share your input file? So i can replace it and send it back.