Multi-Row Formula Average Excluding Zero

[Jeyez]

I was trying to apply AVERAGE(A1:A3,"<>0") formula in Excel to the Multi-Row Formula Tool to exclude zero in the average function, but all attempts failed.

Can someone please help with this? THANK YOU!

[Prometheus]

@Jeyez Can you please upload some dummy data so we could test it?

[caltang]

I'm not sure why you need a Multi-row tool but in the Summarize tool, you can actually choose "Numeric" option and get the "Average without 0s". 

Otherwise, as @Prometheus says, kindly provide the following:

• Sample data
• Expected output (design it in Excel)