Rounding

[CollectionDude]

I'm having problems with rounding, is there a way you can "stop" rounding in a formula?

 

[synapsevampire]

Please post technical information when requesting it.

Crystal version
Database used
Example data
Expected results

Formulas don't always round unless you're using a function that does so, perhaps you mean when using the totext function?

-k

 

[CollectionDude]

sorry about that, I guess the more info the better...I'm running crystal 8.0 and I'm dealing with numeric fields (see below), I'm trying to "box" my Crystal Report with a "canned" report in our system. (trying to prove Crystal is a better tool), anyway the "canned report" doesn't round, so I just want to force crystal to do the same.

Thanks in advance!

CD

If {Payment_History.PAYMENT_TYPE} in ["COR", "NSF"] then {Dbtr_Paymnts_General.Amt_Applied} * -.115

else if {Payment_History.AMT_OVERPAID}={@Total Paid} then 0

else if {Payment_History.AMT_OVERPAID} >0 then NetAmt *.115

else {Dbtr_Paymnts_General.Amt_Applied} * .115

 

[synapsevampire]

Right click the formula and select format field->Number->Customize and select the rounding of interest.

Doesn't round might get you into trouble, consider 100/66.

-k

 

[CollectionDude]

sounds good thanks!