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 · Accepted solution]

@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.

[razzy]

Thank you i was able also to solve it with another approach

[Qiu]

@razzy 
Thank you for the information .
Would it be possible to share yoru approach? 😁