Round Off

Options
Max_M
Max_M Partner, Registered Posts: 2 Partner

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.

Tagged:

Best Answer

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
    edited July 17 Answer ✓
    Options

    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

Answers

Setup Info
    Tags
      Help me…