Formula Issues

[WinterDragon]

Hey guys, I have an interesting question that I do not understand.

I have a field that is a Formula. (@amount) = (#Rtotal4) * {jrnlrow.unitcost} Simple enough. Should multiple the value in RTotal4 by the Unit cost.

Here is the issue..

When Rtotal4 equals 6, It multiples right (6 * 84.38 = 506.28) This is great, but In the next where RTotal equals 10, It screws up. (10 * 84.38 = 843.75) We all know this does not compute. 10 * 84.38 is 843.80.

Thanks,
Winterdragon

 

[WinterDragon]

I just tried creating a Whole new formula, where the RTotal0 (the total of RTotal4) is multipled by the Unitcost. Same thing...

(#Rtotal0) * jrnlrow.unitcost

26 * 84.38 = 2193.75 <-- From Crystal

26 * 84.38 = 2193.88 <-- from calculator

Any ideas?

 

[bdreed35]

84.38 is probably being rounded and its actual value is 84.375.

If you only want to see 2 decimal places, I suggest you introduce the Round function into your formula:

(#Rtotal4) * round({jrnlrow.unitcost},2)

Otherwise, you need to format your formula on the report to show more than 2 decimal places.

~Brian

 

[WinterDragon]

Thanks Brian.. That worked!!

I'm not Sure HOW it worked. The Unitcost data comes from Peachtree as 84.38 when I browse the data. I guess Some things arent meant for us to know..

Thanks Again..


Winterdragon