How do I format while trying to Average?
From SmartWiki
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.
