Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Rounding decimal down

I have a field that displays in sql as

2.9999999999999

when i place the field in the report it displays as 3.00

i would like to display the actual number. i have tried the following ;

formatting the field every which way

round (field,0)

(if (remainder( 1) > 0 and remainder( 1) < 1) then

truncate( ) + 1 else )

any suggestions would be appreciated

Not what you were looking for? View more on this topic or Ask a question