Skip to Content
0
Former Member
Nov 13, 2006 at 12:49 PM

Report builder in BO - Removing trailling zeros

21 Views

I have a field that can have up to 5 deciaml value like 0.12345.. But if the amount is 0.12300 i want to remove the trailling zeros so i would get 0.123 on my report. I have a formula for crystal report but i cant put the 'if' condition in BO Report builder.

Help please

Thanks to all