214
edits
Changes
no edit summary
'''Q: How do I format while trying to Average?
''A: <nowiki>format(AVG(if([this]='criteria',[this],0)),2))</nowiki>
'''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.
[[Category:FAQ]][[Category:Reports]]
''A: <nowiki>format(AVG(if([this]='criteria',[this],0)),2))</nowiki>
'''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.
[[Category:FAQ]][[Category:Reports]]