Skip to Content
Former Member
Jul 13, 2005 at 01:39 PM

help to get rid of zeros


hi folks,

I am reading a data from the table as '3.000X10.000' and I need to get rid of zeros and the decimal On the other hand if it is '3.45X10.5' I need to keep it same.

How can i do that?

Second Question.

I read the numeric value from the field(type currency) like '150.00-' I need to convert to display it in the smartform as '-15%' How to do that?

For that I need to convert the value from currency to char for concatenation. How to do that?