8,849
edits
Changes
no edit summary
'''Q: How do I format while trying to Average?
'''A: ''<nowiki>format(AVG(if([this]='</nowiki>''criteria''<nowiki>',[this],0)),2))</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?'''
To display the result of ''If we want to run an average '' with specified number of values for a particular set of data in conjunction with a 2 digits after decimal format, we need above syntax can be used to use apply the formatting.'' '''Where can this format to accomplish what we wantbe applied?''' ''[[Calculated Field]]'' section in [[:Category:Reports|reports]].
[[Category:FAQ]][[Category:Reports]]