Average calculation excluding zeros and Nulls

[lokeshramamurthy]

Hi,

I am trying to replicate "iferror Average" in alteryx but i am not able to get the accurate numbers Wtd Selling Dist (Avg). 

Attaching an sample data for reference. Kindly help in building an module for the same.

Kind Regards,

Lokesh

[jdunkerley79 · Accepted solution]

Looking at the data you sent, I think:

1. Rename columns based on the first line

2. Add a record ID (row number)

3. Transpose the data

4. Filter the nulls

5. Compute an average grouped by record ID

You could then join back by record ID if needed.