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,

Regards:)

 

 

Jose

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