Rohan Posted September 9, 2021 Share Posted September 9, 2021 Hi, I was using the toNumber() function to convert a string to a useable number, however, ran into a problem where the resulting number was converted to scientific notation and all of the non leading digits were lost. Is there any way to keep the precision of the number? Below is the formula I used $string = "123456789123456" $string.toNumber() Result was 1*10^14 Link to comment Share on other sites More sharing options...
Seeq Team Joe Reckamp Posted September 9, 2021 Seeq Team Share Posted September 9, 2021 Hi Rohan, You'll just want to edit the Number Formatting (https://support.seeq.com/space/KB/570490943/Number%20Formatting) on the resulting formula. The precision is kept, but the formatting is just in scientific notation. Link to comment Share on other sites More sharing options...
Rohan Posted September 9, 2021 Author Share Posted September 9, 2021 On 9/9/2021 at 8:15 AM, Joe Reckamp said: Hi Rohan, You'll just want to edit the Number Formatting (https://support.seeq.com/space/KB/570490943/Number%20Formatting) on the resulting formula. The precision is kept, but the formatting is just in scientific notation. Hi Joe, Thank you for the help. I used your method and it worked for the "trend view", however, scientific notation still showed up for the "treemap" view. Is there any way to change this? 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