Round Off

Solved!
Max_M
Level 1
Round Off

Hello all,

is it possible to round off numbers using the Formula language.

Example
0.6 -> 0

I have only found the classic rounding and the rounding to even or odd numbers.

Thanks for your help.

0 Kudos
1 Solution
sergeyd
Dataiker

Hi @Max_M 

Do you need to round all the decimals to integers using the floor function? This is available by default. So this data: 

first,second
0.3,0.6
1.2,2.3
3.6,3.8

will be transformed this way: 

Screenshot 2022-03-29 at 19.45.31.png

โ€ƒ

View solution in original post

0 Kudos
2 Replies
sergeyd
Dataiker

Hi @Max_M 

Do you need to round all the decimals to integers using the floor function? This is available by default. So this data: 

first,second
0.3,0.6
1.2,2.3
3.6,3.8

will be transformed this way: 

Screenshot 2022-03-29 at 19.45.31.png

โ€ƒ

0 Kudos
Max_M
Level 1
Author

Hi @sergeyd,

 

this is what i needed.

 

Thanks a lot

0 Kudos