Formula to display null values

[Jack_Machesky]

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?

[DRay]

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,

[Jack_Machesky]

Hi DRay,

Unfortunately, this does not help me in my case.

Thanks

[DRay]

Do you not have this option in the Values panel?

[Jack_Machesky]

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?

[DRay]

I also found this post that may help: https://community.sisense.com/t5/embed-analytics/replacin-null-with-0-in-in-calculations-for-column-...

[Jack_Machesky]

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.

[DRay]

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.