Total & Aggregration (Avg function) - how to round up to 2 decimal place

[kytan5]

Hi

 

I used total & aggregation default function to calculation average score for table that has 12 months.  The answer calculated has 6 decimal place but I want to have it round up. How do I fix this? There is nothing on the datapage round it up.

Example

(the actual calculation will give 2 decimal place in the below scenario. just for the purpose of illustrate, i have put in a dummy average value)

Name     Jan                      Feb                    Mar

Name1    4.22                    4.23                  6.3

Name2    4.12                    4.11                  6.44

Mth Avg   4.31123            4.1732               12.74234

 

how  can i round up to 2 decimal point 4.31123 to 4.31?

 

[Mathilda]

Hi Kytan5,

Try using the following formula instead of Average function in the aggregation:

Round(AVG, 2)

 

[kytan5]

19 minutes ago, Mathilda said:

Hi Kytan5,

Try using the following formula instead of Average function in the aggregation:

Round(AVG, 2)

 

Cool! works like a charm! Thanks!

[Kurumi]

Hi - Just to add on this post. If you would like to format the number field to two decimal places - For example, on whole numbers such as 16, it would be 16.00.

You can use this formula

STR([@field:Number], 6, 2)

The STR() function returns a number as a string.

Result:
16 = 16.00
15.345878 = 15.35

References:
- https://howto.caspio.com/function-reference/#:~:text=Str(number%2C length %2C precision)
- https://www.w3schools.com/sql/func_sqlserver_str.asp