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?
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.
Question
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?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
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.