Calculation error while concerting string to number

[Xclipse]

Hi @MYNKJAIN

Use parseInt function for converting a string to an integer. This function returns all rows that contain a decimal, integer, or null value, and skips any rows that don’t.

Please refer to the below Quick Sight community post this might be helpful for you.

Convert calculated field from String to Integert type

If you have a calculated field in Quicksight that is currently of string data type and you want to convert it to a numerical data type, you can use the parseDouble or parseFloat function to achieve this. Here’s an example of how you can convert a calculated field called “MyField” from string to numerical data type using the parseDouble function: parseDouble({MyField}) Similarly, if you need to convert the field to a float data type, you can use the parseFloat function: parseFloat({MyField}) …