It looks like you're new here. Sign in or register to get started.
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?
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.
How do I insert the round in the function expression?
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.
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
to get values between 0 and 5. If want them rounded to the next integer you would do
ceil() rounds to the next integer "above"
floow() rounds to the next integer "below"
An explanation to all function is given if you click on the i next to the function (see screenshot)
Thank you really appreciate the explanation.