Webhook -> Google Sheet wrong comission

[Rodolfo_Santos_Trafe]

I’m receiving the commission amount via webhook, but it comes without formatting, without a comma. The value comes 4122, the right value is 41.22 when I play it for the google sheet without a comma it turns 4122.00… How can I solve this?

[manish_mandot]

This is funny but you can handle it like this;

1. Use Replace function to remove the Comma.

2. Divide it by 100 (do it in the destination field where you are mapping it)

Like this: