not getting the expected value after type conversion 1

[saran26]

Hi All,

I have a short string field in my table and i converted the values in number using the to number function and then try to get the value as int.

int(tonumber({ClearQuest.fldcolumn_2}))

I am always getting the value with two decimal points.

example

I am getting "1.00' instead "1", why it is ? any help will be appreciated?

Thanks
Saran

 

[lbass]

That is the default number format. Right click on the formula->format field->number and select: -1123.

-LB

 

[saran26]

Thanks LB.

I have another question.

I have group by field in the crystal report Chart.

How to change the format of those fields?, Please let me know. If you require, I will submit a new message.

Thanks
Saran

 

[lbass]

You should always start a new thread for a new topic, such as this. In your new thread, you should provide more information, e.g., what is the datatype of the on change of field? How does it currently appear? How do you want it to appear?

-LB