Excluding zeros from Averages in a table

[#1]

Hello,

I was wondering if it was possible to exclude zeros when trying to get the average of a column in a table . Currently the average is including the Zeros ($) making the figure innacurate. Please help.

Thanks,

Kevin

[danielrozental]

You could try

Avg({<Value-={0}>}Value)

or

Avg(if(Value>0,Value))