toNumber() function

[Rohan]

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

[Joe Reckamp]

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.

[Rohan]

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?