Rookie
1
I’m trying to create a simple that takes a number ‘x’ in a field and increases or decreases by a percentage.
ie ‘x’ multiplied by a random number, and that random number has a range between 0.88 and 1.11.
The result would be a constant ‘x’ that increases or creases within a range of 0.88 and 1.11.
Is such a calculation possible?
dave
2
Yes. The formula would be
x * (0.88 + 0.23*rnd())
gary
3
…or you could use randominteger for the range divided by 100 to get the random values between 0.88 and 1.11.
x=x * randominteger(88,111)/100
1 Like
Rookie
4
wow. very clever. thank you.