Jump to content

toNumber() function


Recommended Posts


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"


Result was 1*10^14

Link to comment
Share on other sites

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

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