Unique Random number generation

razzy

Hi All,

Any thought on this please?

I am using this formula to generate random number using two fields that were identifiers the formula works but i am having duplicates i however want a unique value of the numbers of any unique records any thought will be appreciated;

Formula Used:  

HexToNumber(Left(MD5_UNICODE([Field1]+[Field2]),7))*1000/268435455

Qiu

@razzy 
I dont see any random function in your formula, we can add one RanIt function.
But still, there is still a chance of getting duplicated, which can be reduced by increase the Range of RanInt.

0312-razzy.yxmd