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(SUM([Total TotalSales]))) END" but I am having no success. Any Ideas?
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?
This also did not work. I am still looking for a solution to this issue. Again, I believe that it is an issue using a blox widget.
Hello Jack_Machesky,
I brought this up internally, and they recommended that you open a support ticket so we can get a closer look at this. Can you please submit a ticket through our support portal?
Thank you.
