Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
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 now!
  • 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.

needmoremoney (TechnicalUser) (OP)
23 Mar 06 18:34
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?
AlvarHanso (MIS)
23 Mar 06 19:43
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
Helpful Member!  lbass (TechnicalUser)
23 Mar 06 19:55
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
needmoremoney (TechnicalUser) (OP)
23 Mar 06 19:58
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.
lbass (TechnicalUser)
23 Mar 06 20:03
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
needmoremoney (TechnicalUser) (OP)
24 Mar 06 3:02
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!

Back To Forum

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