Currency Rounding Issue

[Guest]

I have a situation where I am trying to divide out a pooling charge for a
cellular phone bill. In the report footer, I have two fields GT_PoolCharge
(currency) and GT_PhoneCount(fixed,0). The charge per phone is
GT_PoolCharge/GT_PhoneCount.

PoolCharge = 3863.60
PhoneCount= 92

The charge per phone is displayed as 42.00. In my subtotal field, I am
doing the following...since I can't put a sum on the detail calculated field.

=[GT_PoolCharge]/[GT_PhoneCount]*[CC_PhoneCount]

In one subtotal example for 7 phones the subtotal is 293.97

So, I have three problems

1. The subtotals do not equal the sum of detail lines.
2. The sum of subtotals do not equal the pooling charge.
3. The sum of all columns do not equal the bill total.

I had previously done this report in Excel and it seemed to take care of the
rounding.

Help!

Donnie

 

[Stefan Hoffmann]

hi Donnie,

=[GT_PoolCharge]/[GT_PhoneCount]*[CC_PhoneCount]

Use an explicit cast:

=CCur([GT_PoolCharge])/CCur([GT_PhoneCount])*CCur([CC_PhoneCount])


mfG
--> stefan <--

 

[Guest]

Stefan,

I get the same result, $293.97!

Donnie

hi Donnie,

=[GT_PoolCharge]/[GT_PhoneCount]*[CC_PhoneCount]

Use an explicit cast:

=CCur([GT_PoolCharge])/CCur([GT_PhoneCount])*CCur([CC_PhoneCount])


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi Donnie,

I get the same result, $293.97!

Try
?CCur(CCur(3863.60) / CCur(92) * CCur(7))


mfG
--> stefan <--