How do I format while trying to Average?
Revision as of 11:54, 24 March 2009 by Thu (talk | contribs) (How do I format while using aggregation? moved to How do I format while trying to Average?: More appropriate title)
Revision as of 11:54, 24 March 2009 by Thu (talk | contribs) (How do I format while using aggregation? moved to How do I format while trying to Average?: More appropriate title)
Q: How do I format while trying to Average?
A: format(AVG(if([this]='criteria',[this],0)),2))
Why do we do this?
If we want to run an average of values for a particular set of data in conjunction with a 2 decimal format, we need to use this format to accomplish what we want.