How to convert an exponential number for Google Sheets (error)

[Frederic_Pasman]

Hi all,

I’m fairly new to Make and have my first scenario build. Great platform!

After running my scenario I get this error:

Failed to map 'values.3': Function 'parseNumber' finished with error! '4.7402051873838375e7' is not a valid number or using unsuitable separator.

Can someone please explain to me how to convert this number so I can successfully write this to my Google Sheet?

"price": "4.7402051873838375e-7",

Thanks in advance.

With regards,
Fred.

[L_Duperval]

Hi @Frederic_Pasman and welcome to the Make Community!

Assuming you have the correct value and that the “e-7” is not an error, maybe this post might help:

Scientific notation

This is an excellent question! Error when formatting scientific numbers Usually one would use the formatNumber function to display numbers as a string (text) [Screenshot_2023-09-04_160934] But when the number is a scientific notation, this throws an error [Screenshot_2023-09-04_160900] Failed to map ‘value’: Function ‘formatNumber’ finished with error! ‘1.0442665000000301e+21’ is not a valid number or using unsuitable separator. Why there is such an error These sort of numbers being dis…

L

[Frederic_Pasman]

Hi @L_Duperval. Thank you very much for this answer! Now I understand a lot more about the approach for these kinds of problems.