Rounding Down

[GeneN24]

Is there a way to format an amount field to round down?

Thanks

 

[IdoMillet]

Use the Truncate() function.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[oneilltnc]

Do you need to see the decimal places or just the whole number? If you just want to see the whole number you can create a formula like this...

Fix(yournumberfield)

Hope this helps.

 

[GeneN24]

Ido, your suggestion worked like a charm. Hopefully with more experience I will become as innovative as those on this board that give the excellent solutions to our problems.

Thanks,
Gene

 

[oneilltnc]

I'm not exactly sure what kind of field you actually have delcared, but if you use this formula it should work.

Fix(ToNumber(yourfieldhere))

This should convert your Currency to a number and if you still want to show the currency symbol you can then right click on the formula field and go to the number tab and click the customize button. If you go to the currency tab and check the enable currency symbol option then it will look like your currency field.