7 Replies Latest reply: Apr 14, 2016 11:08 AM by John Blomqvist RSS

    How can I generate Random negative and Positive values for a field?

    John Blomqvist

      Hi all,

       

      Let's say I have a following table like this:

       

      OrderIDValue
      133.44
      288.99
      355.99
      4-157.08
      545.87
      6-34.99

       

      How can I generate random Negative and Positive values for the Value field using the rand() function?