Exp() function causing overflow error

In my QS dashboard, I have a calculated field = exp(-x), where x is a non-negative value. The calculated expression works well without the exp function. However, I get an ‘overflow error while performing a exp operation’. Any suggestions how to resolve this?

Hi @spo, welcome to the QuickSight Community! It seems that the error may be due to large numbers. Can you follow a solution similar to the one seen here:

You may need to play around with the multiple, but here is an example I was playing around with:


Image includes Dummy Data

Hope this helps! Feel free to reach out again if you have any additional questions.