I need help with Javascript Node to Data Transformation

Hey guys, how are you?

I need some solution so that I can add a comma “,” two decimal places in the opposite direction.

It turns out that the value of “Invoicing” that I get from the webhook is not separated by commas. Instead of seeing “57.00”, it comes with “5700” and I need to format it to add it to Sheets.

I believe that the best way to solve this is to use javascript with a custom code, but I don’t understand this language. can you help me?

Follow my flow below:

Prints:

Try with dividing it with 100.

{{ $json["body"]["transaction"]["total_price"] / 100 }}
1 Like

Thanks bro! Now it worked.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.