Check Digit Validation (Mod 97)

[Jose Villalobos]

Hello experts!

 

I need to calculate modulo 97 (mod formula) for a 23 digit long number (real data type).

I'm desperate and I've read a lot about the topic...I'm aware that spotfire and excel both have a precission of 15 digits for math formulas.

Is there any work around for this topic

 

I exported my column as a string to avoid spotfire rounding my 23 digit right from the get go, but, once I convert that data to real in a calculated column, it rounds the numbers once again (due to the 15-digit lenght restriction).

So, basically, I first need to resolve somehow the 15 digit restriction so I can then calculate mod for the 23 digit of lenght numbers.

 

Thanks in advance,

Regards:)

 

 

Jose