I guess that Tableau may recognize it as NULL in case of no records counted.
Thus, why not try the following?
CASE COUNT([Sales_Id]) when NULL THEN 0
ELSE COUNT([Sales ID]) END
Hope this may help you!
I tried your calculation and still does not return anything. I will take a closer look at the data and see if I can provide some more information.
Thank you for the response. Brent
1 of 1 people found this helpful
You can try this formula to see if it displays 0.
With testing, I can see the formula works in a table when I am not filtering the salesperson ID. (correctly displays a zero).
- Your formula works
Filtered to 1 salesperson
But, as I apply the sales person's filter the category goes away
- I think this is the issue
- There is no category, so it won't display anything
Does this make sense? Thank you!
Just to provide some more details if someone is following this thread, there is a very good explanation to the ZN function HERE
it covers this topic but does not quite provide the solution to my problem.