I need to create a unique key on the fly in a report. I have a report which pulls everyone with a current balance but there can be multiple poeple who have a balance in more than one account type.

 

I thought I would use the participant account number, then concatenate a random number and I'd be golden.

 

However, the result is a string with a ".00" at the end

 

I tried left (XX to limit the key but I end up with some "keys" with a "X," which is unacceptable since I will need to export to csv in inder to import into a 3rd party application.

 

Any suggestions?

 

What I am looking to achieve is a simple unique 13 digit number for roughly 16000 records.