Jose Villalobos Posted May 16, 2019 Share Posted May 16, 2019 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 More sharing options...

## Recommended Posts

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