🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

round real values to the n-th decimal?

User: "Fred12"
New Altair Community Member
Updated by Jocelyn

hi,

is there any operator than can round or cut of some real number on the n-th decimal, e.g on the 5 number after the comma or so?

do this for one or any columns?

Find more posts tagged with

Sort by:
1 - 4 of 41
    User: "Telcontar120"
    New Altair Community Member

    I believe the "round" function available in generate attributes will do what you want quite easily!  

    You also have the 'format numbers' operator but that will turn it into a nominal value.

    User: "SHSguy"
    New Altair Community Member

    How do I insert the round in the function expression? 

    Tried using 

    Function expression

    rand(round())

     

    also two separate function expressions no luck 

     

    attribute 1 rand()

    attribute 1 round()

     

    also if maybe you know, how do I limit the random function between two numbers rand(1,5) does not work at all. 

     

    Thank you in advance. 

     

    User: "Edin_Klapic"
    New Altair Community Member

    Hi @SHSguy,

     

    I am not sure what you want to achieve in your first use case.

    If you want to round a random number the order of functions is wrong. It needs to be round(rand(),x) with x being the number of decimals to round to.

     

    Regarding your second question:

    The rand() function always delivers a floating point number between 0 and 1. So one possible solution would be

    rand()*5

     to get values between 0 and 5. If want them rounded to the next integer you would do

    ceil(rand()*5)

    ceil() rounds to the next integer "above"

    floow() rounds to the next integer "below"

     

    Happy Mining,

    Edin

     

    P.S.:

    An explanation to all function is given if you click on the i next to the function (see screenshot) image.png

     

     

     

     

    User: "SHSguy"
    New Altair Community Member

    Hi Edin, 

     

    Thank you really appreciate the explanation.

     

    Best Regards,

    Nick