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
Assuming you are using the formula SUM([Revenue]) you could try:
CASE WHEN ISNULL(SUM([Revenue])) THEN 0 ELSE SUM([Revenue]) END
When using this approach, I am met with "
Error querying your data model An unknown error has occurred."
