Forum Discussion

Re: Lists and Random Functionality

I have this in my bag of tricks to generate a Random number.  If you really cared how random it was you would have to run your own statistical test I suppose. Since it is based on the record ID then you have to decide if that works for your process because of course this pseudo-random number will never change for a particular Record ID


ToNumber(Right(ToText(Int([Record ID#]*9973/127)),4))



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

1 Reply

  • AnthonyMcIntyre's avatar
    AnthonyMcIntyre
    Qrew Member
    Thank you for the formula, it's getting me one step closer to solving this issue!

    ------------------------------
    Anthony McIntyre
    ------------------------------