Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could try
Avg({<Value-={0}>}Value)
or
Avg(if(Value>0,Value))