Calculation error while concerting string to number

[MYNKJAIN]

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}) …

[Xclipse]

Hi @MYNKJAIN

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

[Xclipse]

Hi @MYNKJAIN

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!