Payment is getting captured without a decimal point from razorpay using a webhook

[Vireesh]

I am trying to capture a payment and give course access to the user in mypipeline. But while capturing the payment from razorpay pabbly is taking the amount without a decimal point because of which when I captured the payment of Rs-499/- it is reflecting in the webhook response as Rs-49900/- and the same is being reflected in my CRM which is causing issues in the total value of the sales made.

How to fix this?

 

[shahidul islam pranto]

You can use an action block called "Number Formatter". In this number formatter, select "Spreadsheet Formula".

In that formula, divide the number by 100. Then transfer the resulting number from the number formatter to your CRM.

 

[ArshilAhmad]

Hi @Vireesh,

As Shahidul states, you can divide the incorrect amount by 100 using Number Formatter to get the correct amount.

 

[Kraft Karnika]

You can use an action block called "Number Formatter". In this number formatter, select "Spreadsheet Formula".

In that formula, divide the number by 100. Then transfer the resulting number from the number formatter to your CRM.

thank you so much