Difference between revisions of "How do I format while trying to Average?"
From SmartWiki
| Line 1: | Line 1: | ||
'''Q: How do I format while trying to Average? | '''Q: How do I format while trying to Average? | ||
| − | ''A: <nowiki>format(AVG(if([this]='criteria', | + | '''A: |
| − | + | ''<nowiki>format(AVG(if([this]='criteria',this],0)),num))</nowiki>'' | |
| + | |||
| + | <nowiki>where num = integer indicating scale of the decimal number.</nowiki> | ||
| − | '''Why do we do this? | + | '''Why do we do this?''' |
| − | '' | + | To display the result of ''average'' with specified number of digits after decimal, above syntax can be used to apply the formatting.'' |
| − | '''Where can this be applied? | + | '''Where can this be applied?''' |
'' Calculated field'' section in [[Reports]] | '' Calculated field'' section in [[Reports]] | ||
[[Category:FAQ]][[Category:Reports]] | [[Category:FAQ]][[Category:Reports]] | ||
Revision as of 10:13, 25 March 2009
Q: How do I format while trying to Average?
A: format(AVG(if([this]='criteria',this],0)),num))
where num = integer indicating scale of the decimal number.
Why do we do this?
To display the result of average with specified number of digits after decimal, above syntax can be used to apply the formatting.
Where can this be applied?
Calculated field section in Reports
