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?
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?
This is funny but you can handle it like this;
Use Replace function to remove the Comma.
Divide it by 100 (do it in the destination field where you are mapping it)
Like this:
