Smartstaff
137
edits
Changes
no edit summary
'''Q: How do I format while trying to Average?
''A: <nowiki>format(AVG(if([this]='criteria',[this],0)),2num))</nowiki> where num = integer indicating scale of the decimal number.
'''Why do we do this?
''If we want to run an To calculate average of values for a particular set of data in conjunction with a 2 decimal formatnumbers, we need above syntax can be used to use apply the formatting.'' '''Where can this format to accomplish what we want.be applied? '' Calculated field'' section in [[Reports]]
[[Category:FAQ]][[Category:Reports]]