NUMBERFORMAT(NUMBER_OF_DECIMALS)
Rounds the given number to the given number of decimal places. If the rounded number has fewer decimal places than desired, it will be padded with zeroes to maintain a consistent number of decimal places.
#results in 82.1{AVG(LOCATION.SCORE)}
#results in 82.10
{AVG(LOCATION.SCORE).NUMBERFORMAT(2)}
#results in 82.1000
{AVG(LOCATION.SCORE).NUMBERFORMAT(4)}
#results in 96.237
{AVG(COUNTRY.SCORE)}
#results in 96.24
{AVG(COUNTRY.SCORE).NUMBERFORMAT(2)}
ROUND(NUMBER_OF_DECIMALS)
Rounds the given number to the given number of decimal places. If the rounded number has fewer decimal places than desired, it will not be padded with zeroes.
#results in 82.1{AVG(LOCATION.SCORE)}
#results in 82.1
{AVG(LOCATION.SCORE).ROUND(2)}
#results in 96.237
{AVG(COUNTRY.SCORE)}
#results in 96.24
{AVG(COUNTRY.SCORE).ROUND(2)}