INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Sum of Group field Rounding number

Sum of Group field Rounding number

(OP)
Hello,

I have a Sum field that displays the total of a collumn. Unfortunately, the total is not correct. It is off by a few cents. I sent the field for two decimal places but it is still incorrect.

For example, if I manually added the collumn it's 45.67 cents but the report rounds off to 45.69. Any ideas?

RE: Sum of Group field Rounding number

Whaatup! Hey what is the Field size, format, and Decimal place say in the general tab when you look at the table in design view in access. Still access 97 right? When you right click and format the field in crystal, does it use Custom Style or did you select one of the formats there like [-1123.00]Also what is the grouping and in what section is the column field you are trying to summarize.

Much love to my bro's in selma!

Adam

RE: Sum of Group field Rounding number

This probably means that the fields above it are being rounded for the display, but that the actual number is being used in the summary. For example:

actual       display
10.0089      10.01
10.0089      10.01
13.4649      13.46
12.1949      12.19
45.6776      45.68

If you want the displayed totals to be summed, then replace the individual values with a formula:

round({table.number},2)

Then insert a summary on this rounded value.

-LB

RE: Sum of Group field Rounding number

(OP)
Hey dude.. you remember my handle..

It's weird, because use used the format to round the number to two decimals but crystal is still not totaling the field correctly. For example:

There are my amounts:

100.00
100.00
100.23
100.44

The total is 400.67
but crystal displays 400.79

When I format the field to show four decimal points my amounts are

100.0000
100.0000
100.2343
100.4444

The total is 400.6787
But crystal displays 400.6789

Any help, thanks.

BTW: Nice to see you dude.

RE: Sum of Group field Rounding number

Note that the formatting is for display purposes only, not for calculations, so if you want to sum the rounded amounts you will have follow my earlier suggestion. It is not that CR is calculating incorrectly.

-LB

RE: Sum of Group field Rounding number

(OP)
Thanks lbass. I'll try it out and let you know.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close