Even though it sounds simple,but its a nostalgia for me.
Let me explain you the requirement.I have the data like the one below.
In the report I have a filter named Month and two boxes as shown below.
Month : March
Month : April
The logic for IN/OUT calculation is Count(distinct Name) for each of the status.
Now here I want 0 to be displayed in case of Blank.I tried every possible way,whether it be IIF(ISNULL....) or ZN but could not get the required results.
It is not happening because the data is not at all present for that particular status and month in the database.
But still I want this to be displayed as 0 (requirement of the client).
Any help in this regard will be highly appreciated.
Looking forward to hear from the best of the Tableau minds here
Thanks in advance!!!