Format Numbers To Integer

[#1]

Hello,

Apologize as this might be a simple question.  I'm trying to format numbers in Edit Script so that float numbers is converted to Integer.  Which function does this trick?

Your help is much appreciated!

[#2 · Accepted solution]

Round( value)

Ceil ( value)

Floor( value)

[swuehl]

If you only want to format the field, but keep the floating point number internally, use

...

num(FIELD,'0') as FIELD,

...

If you want to keep only the integer part, use

..

floor(FIELD) as FIELD,

...

to truncate to integer

or

...

round(FIELD,1) as FIELD

...

for a rounded integer.

Hope this helps,

Stefan