Check Digit Validation (Mod 97)
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,