How to convert decimal number into integer

[Picture008]

Hi All,

I have number like 5.00 then i want convert it into number like 5.This number is came from while writing the array formula.
I used Int(x) round(x) and Truncate(x).
but it is not working, so can have solution please.

Thank you very much.

 

[synapsevampire]

They are already the same, what you're speaking to is the display format.

Right click the field and select format field->number and set it to 0 decimals.

It's not a conversion, 5.00 = 5, it's a display property.

-k

 

[Picture008]

The number is like ArrSumTypeCount[int2] and it is showing in the report formula like 5.00 it is not field to convert from format field.
Thanks,

 

[synapsevampire]

No idea what "it is not field to convert from format field.
" means... I suggested that you try formatting it and you come back with that. All fields can have their formatting changed, did you mean that it isn't a number?

You posted that it was a number, so I assumed that you meant it.

You can right click any field and select browse data and Crystal will tell you what it believes to be it's data type.

Your last post states that it's a INT2 so it sounds like it is a number and it's just not formatted correctly.

If it's not a number, try creating a formula of:

val({table.field})

And then use the formatting as described above.

-k