Rounding Formula Based field to Nearest Hundredth

[Cheryl3D]

Hi:

I'm working on a report in Crystal Reports version 8.5. I have a formula field that calculates number fields (sums the two fields). Here is the formula:

Sum ({qryAnnex_View.NRCost}, {qryAnnex_View.Categories})+Sum ({qryAnnex_View.NRWorkyearCost}, {qryAnnex_View.Categories})

What is the correct syntax for incorporating the Round function - Round(x,#places) - into the formula above, if I want the calculated result to be rounded to the nearest hundredth?

For example, I have the number 104,728.95 want it to stay just that and not be rounded off to the nearst one which would be 104,729.00 (which is happening now in my report).

Would the correct syntax be something like?

Round(Sum ({qryAnnex_View.NRCost}, {qryAnnex_View.Categories})+Sum ({qryAnnex_View.NRWorkyearCost}, {qryAnnex_View.Categories}),.#00)

Any advice is greatly appreciated.

Thanks,
Cheryl

 

[dgillz]

Round({YourNumber},-2) will round to the nearest hundred.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

Right click on the summary field->format field->number->and select
"-1,123.00".

-LB

 

[lyanch]

It is probably a display problem rather than a rounding problem. Check your display format. Crystal doesn't generally round things off for you, but will keep totally insignificant amounts of digits. Try putting just 123456123456.98 in a formula. Crystal will display the whole thing..

Lisa