Skip to Content
Oct 28, 2016 at 01:12 PM

How to convert .10 number to whole number in crystal report


Hello Experts!

I would like to insert a field in crystal report that will be converted to a whole number. It comes from a UDF from the OCRD (Business Partner Master Data). The values are decimal , most values that will be entered to that UDF is .10, .20 and .30.

When inserting this field to the crystal report, I want it to appear as a whole number. I plan to create a formula field but I'm not sure what formula to use cause I'm new to SQL etc. :) Or can you suggest another option where I can convert the decimal value from SAP to a whole number in Crystal report?