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
Hello Jack_Machesky,
Thank you for your question. Can you take a look at this document and let us know if it works for you?
https://docs.sisense.com/main/SisenseLinux/replacing-missing-values-with-zeros.htm
Thank you,
Hi DRay,
Unfortunately, this does not help me in my case.
Thanks
Do you not have this option in the Values panel?
No, I do not have that option. I think it may be because I am using a blox widget. Any ideas on how we could activate that function for a blox widget?
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
