CFLib.org – Common Function Library Project

Description:
ColdFusion's built-in arrayAvg() function calculates an average by taking the sum of a set of numbers and then dividing that sum by the total count of the numbers. When the set of numbers contains one or more zeros, this produces an inaccurate average when the developer wishes to average only those values which are greater than or equal to 1.

Return Values:
Returns a number.

Example:

<cfset data = listToArray("5,0,5,3,0")>
<cfoutput>
Built-in ArrayAvg: #arrayAvg(data)#<br>
AverageWithoutZeros: #averageWithoutZeros(data)#
</cfoutput>

Parameters:

Full UDF Source:

<cfscript>
/**
 * Calculates the average of a set of numbers omitting values less than 1 from that average.
 * 
 * @param data 	 The array to average. (Required)
 * @return Returns a number. 
 * @author David Simms (&#100;&#115;&#105;&#109;&#109;&#115;&#64;&#100;&#99;&#98;&#97;&#114;&#46;&#111;&#114;&#103;) 
 * @version 1, January 12, 2004 
 */
function averageWithoutZeros(data) {
	var counter = arrayLen(data);
	
	//remove zeros
	for(;counter gte 1;counter=counter-1) {
		if(data[counter] lt 1) arrayDeleteAt(data,counter);
	} 

	if(arrayLen(data)) return arrayAvg(data);
	else return 0;
}
</cfscript>