convert a float field to integer

[Anonymous]

Hello, everyone.

I need help how i can to convert a float field to integer.

this is my field

Thanks,

Regards.

[swuehl]

Have you tried a rounding function like ROUND(FIELD), CEIL(FIELD), FLOOR(FIELD)?

[Anonymous]

Now , try it but did not work.

Num#(ABAST,'0.0')

Num(ABAST,0)

Num(ABAST)

Rount(ABAST)

Floor(ABAST)

and CEIL(ABAST)

[swuehl]

Could you upload a small sample QVW that shows your issue / field?

[Anonymous]

Of course, thanks.

[swuehl · Accepted solution]

Your ABSAT field is a text field. before you can use numerical functions like rounding functions, you need to interpret it as number, using num#(). When using num#() you need to specify a correct format code and you may need to specify the separators if they differ from your defaults.

This seems to work for me (only one distinct ABSAT value contained in the QVW to test):

round(num#(ABSAT,'#,#',',','.'))

[Anonymous]

Thank you very much swuehl‌ , is working perfect.

Regards.

[FGee]

A round function works pretty well for your problem.  Other useful functions are the ceil and floor function depending on how exactly you would want to manipulate your data.