Jump to content

Check Digit Validation (Mod 97)

Jose Villalobos

Recommended Posts

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,





Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...