Round number to get the whole part

[pagliaci]

Hi, I have 2 columns: Y is a decimal number, and "#maint. needed" should tell me how many actions I need to do in base on the number before decimals of the Y column

#maint. needed = LEFT(ZMPF[Y], 1)

What I want is this result:

y= 0,005 --> # maint =0

y= 0,9 --> # maint =0

y= 1,8 --> # maint =1

y= 2,99 --> # maint =2 

But my maint column is doing, like the picture:

y= 0,005 --> # maint =5

y= 0,03 --> # maint =3

I suspect it does that because of the scientific terminology, but I don't know how to fix it. 

[pagliaci · Accepted solution]

I got it, I needed to use TRUNC ()!! Thanks 🙂

[tamerj1]

Hi @pagliaci 

use ROUNDDOWN function 

[pagliaci]

It doesn't work, I tried

[tamerj1]

Did you check the data type?