Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon!
I am not sure how to make a random value in a field.
For example:
If the field A = 2 then random between 1 and 10, if field A = 3 then random between 40 and 60.
I used it, but it did not work:
- Interval
- IntervalMach
- Rand
What can I do?
Thanks
May be like this
If(A = 2, Rand() * (10-1) + 1, If(A = 3, Rand() * (60-40) + 40)) as RandNum
Quite did not get that. Can you explain a little with some sample data and expected output you are looking for?
May be like this
If(A = 2, Rand() * (10-1) + 1, If(A = 3, Rand() * (60-40) + 40)) as RandNum