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

Latest revision as of 09:54, 30 April 2013

Q: How do I format while trying to Average?

A: format(AVG(if([this]='criteria',[this],0)),num))

where:
 criteria = criteria set by author of report and 
 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.

@@ 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]='</nowiki>''criteria''<nowiki>',[this],0)),</nowiki>''num''))''
+ where:
+  criteria = [[:Category:Criteria|criteria]] set by author of report and
+  num = integer indicating scale of the decimal number
-'''Why do we do this?
+'''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 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 [[:Category:Reports|reports]].
 [[Category:FAQ]][[Category:Reports]]