Remove Decimals

[Anonymous]

Hi All

Needed help with the following please.

I am getting the current and want the ones listed below

so i get 78.8 but want 78 etc

Is there a function for this in the code please?

Thanks

Current	Need
78.8	78
300.8	300
250	250
239.1	239
286.1	286

[Anonymous · Accepted solution]

floor is the function you would use.

[Anonymous]

I tried this and in a stright table it changes my number from 78.8 to 20?

[ThornOfCrowns]

Set the Number Type to Integer in the Table Properties.

[Anonymous]

see the attached sample file which will help you

[Anonymous]

if it is in straight table, follow the attached screen shot

[sunny_talwar]

Floor(YourCurrentExpression) changed the number from 78 to 20???

[Anonymous]

Thanks Everyone for the replies!