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

Q&A
, , ,
4

Hello @Kousic

When you say it wasn’t working do you mean it returned an error when you tried to save or the values it returned were wrong?

For your periodOverPeriodPercentDifference calculation you could try something like the following:
Check and replace null = ifelse(isNull({cf_active_deals}), 0, {cf_active_deals})
WoW= periodOverPeriodPercentDifference({Check and replace null}, {ad_date}, WEEK,1)

Basically what I’m trying to do is recreate the cf_active_deals (or other metric column) so that NULL is 0. Then do my calculating on that. If you add these to a table you’ll need to add the recreated field and then hide it to avoid a calc reference error.

You can also add a sample dataset to arena, that would be easier to troubleshoot: