Difference between revisions of "How do I format while trying to Average?"
From SmartWiki
m (How do I format while using aggregation? moved to How do I format while trying to Average?: More appropriate title) |
|
(No difference)
| |
Revision as of 10:54, 24 March 2009
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.
