OriginalPostID-257792
Discussion posts and replies are publicly visible
What if the range is decimal values like -0.001 to +0.001, cause your solution only works for integer number, any help would appreciated
There's only one rand() function and it always returns a decimal between 0 and 1. So, you have to manipulate that number to get what you need. For example, the following would work for the scenario you described:
(rand()-0.5)/500