Jump to content
  • 0

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





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.


(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

2 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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...