Why Quick Sight default add table calculation (Percent difference) doesn't have any option to handle the NULL divide by zero errors?Its seriously lagging behind in terms of basic features compare to other BI tool available in market

[duncan]

Hello @Kousic , welcome the QuickSight community!

To my knowledge there is no way to tell QuickSight how to handle null values in table calculations. That being said, other users have found work arouns using ifelse and coalesce.

Here’s an example:

Excluding null values from calculations but not replacing them as 0

I’m trying to make the below calculation to apply to various categories in the data. These calculated fields are aggregations from the data which contain scores from 0-10 as well as empty cells where a score wasn’t assigned. ({115 weighted}+{115b weighted }+{115d weighted}+{115e weighted}+{111 weighted})/100 when trying to execute this calculation some of the categories do not populate, I believe this may be because some categories have fields such as {111 weighted} that have no scores just n…

Let me know if this is what you were looking for. I will also mark this as a feature request for the QuickSight team.