Formula to display null values
I have a widget that I would like to replace all null values with values of "0". I am trying to use the following formula: "CASE WHEN ISNULL (PASTYEAR(SUM([Total TotalSales]))) THEN 0 ELSE (PASTYEAR(...
Forum Discussion
Hi DRay,
Unfortunately, this does not help me in my case.
Thanks
I also found this post that may help: https://community.sisense.com/t5/embed-analytics/replacin-null-with-0-in-in-calculations-for-column-chart-and/m-p/15211
