Difference between revisions of "How do I format while trying to Average?"

Revision as of 10:49, 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 calculate average of values with decimal numbers, above syntax can be used to apply the formatting.

Where can this be applied?

Calculated field section in Reports

@@ Line 1: / Line 1: @@
 '''Q: How do I format while trying to Average?
-''A: <nowiki>format(AVG(if([this]='criteria',[this],0)),2))</nowiki>
+''A: <nowiki>format(AVG(if([this]='criteria',[this],0)),num))</nowiki>
+      where num = integer indicating scale of the decimal number.
 '''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.
+'' To calculate average of values with decimal numbers, above syntax can be used to apply the formatting.''
+'''Where can this be applied?
+'' Calculated field'' section in [[Reports]]
 [[Category:FAQ]][[Category:Reports]]