avg_if(group,condition,value)

Tinderbox Icon


Operator Type:   Boolean
Operator Scope of Action:   Conditional Group

This computes the arithmetic mean of a value in a group, as filtered by an expression. For example

avg_if(child(/Catalog),$Price!=0,$Price) 

returns the average price of all the items in Catalog, ignoring any items that have a price of 0.


Up: Full Operator List
Previous: AttributeName(pattern)  Next: between(val,min,max) 

[Last updated: 14 Dec 2009, using v5.0]

Google search aTbRef for:  

Licensed under Creative Commons Attribution-Noncommercial-Share Alike 3.0 License
[See aTbRef CC licence Attribution/Waiver info info]

Creative Commons License

Made with Tinderbox