Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, everyone.
I need help how i can to convert a float field to integer.
this is my field
Thanks,
Regards.
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,'#,#',',','.'))
Have you tried a rounding function like ROUND(FIELD), CEIL(FIELD), FLOOR(FIELD)?
Now , try it but did not work.
Num#(ABAST,'0.0')
Num(ABAST,0)
Num(ABAST)
Rount(ABAST)
Floor(ABAST)
and CEIL(ABAST)
Could you upload a small sample QVW that shows your issue / field?
Of course, thanks.
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,'#,#',',','.'))
Thank you very much swuehl , is working perfect.
Regards.
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.