round real values to the n-th decimal?

Fred12

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?

Telcontar120

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.

SHSguy

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. 

 

Edin_Klapic

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)

 

 

 

 

SHSguy

Hi Edin, 

 

Thank you really appreciate the explanation.

 

Best Regards,

Nick