AVERAGEEXZERO
The AVERAGEEXZERO function returns the average (arithmetic mean) of its arguments excluding zeros, which can be numbers or node references.
Syntax
averageexzero(value1,[value2]....)Arguments
value1 – The first node or number to be averaged. This is a required argument.
value2,...– The additional nodes or numbers to be averaged. These are optional arguments.
Example
averageexzero(East, South, Central, West)Returns the average of the four regions excluding zeros