• 0

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

## Question

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?

## Recommended Posts

• 0

Hi Kytan5,

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

`Round(AVG, 2)`

##### Share on other sites

• 0
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!

##### Share on other sites

• 0

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

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.