Hi, I am using a WhatsApp bot as my source of data, and I receive inputs in various regional languages through webhook.

For the fields declared as type NUMBER, I am not to store the incoming data from webhook of different language as it gives Field "Amt_Spent_New" cannot accept the provided value: Could not parse number. (Attached screenshot below)

If I convert the NUMBER type field to TEXT, I am able to store the data but not perform operations on it

How can I tackle this use case?

Any advice or help is much appreciated!, Thank you