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
When 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]))
