I am trying to use random (#,#), but how do I use it to generate a random decimal between for example random(.10,.30)?
Select Type “Formula” and enter this function in the text field:
round(random(0.1, 0.3), 2)
This will pick a random number between 0.1 and 0.3 and round it to 2 decimals.
Thanks, this worked.