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)),num))</nowiki> '' <nowiki>where num = integer indicating scale of the decimal number.</nowiki>
'''Why do we do this?'''
To display the result of '' To calculate average '' with specified number of values with digits after 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]]