Displaying data for null values
I have multiple widgets on my dashboard that I would like to show values of "0" for if they are null values. What is the best way to achieve this?
Forum Discussion
6 Replies
Assuming you are using the formula SUM([Revenue]) you could try:
CASE WHEN ISNULL(SUM([Revenue])) THEN 0 ELSE SUM([Revenue]) ENDWhen using this approach, I am met with "
Error querying your data model An unknown error has occurred."It looks like this approach is working for a formula that only contains a SUM function, but when I try and use it for a formula using a PASTYEAR(SUM()) formula, it is not working. I will paste my formula it is not working for below: Pastyear(sum([Total Sales]))
hii...You can achieve this by setting up conditional formatting or logic in your dashboard software to replace null values with "0" before displaying them.
Hello Jack_Machesky,
Can you take a look at this documentation and let us know if it addresses your use-case?
https://docs.sisense.com/main/SisenseLinux/replacing-missing-values-with-zeros.htm
Thank you.
Hello David,
In my case, this does not solve the issue I am facing. I am looking at blox widgets that are pointed at a salesforce database, and was wondering if I could return values of 0 for all null values.
Thanks,
Jack
