## 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?

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

Much love to my bro's in selma!

Adam

## RE: Sum of Group field Rounding number

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

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

-LB

## RE: Sum of Group field Rounding number