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 accountSign in
Already have an account? Sign in here.
Sign In Now