1 Reply Latest reply on Mar 4, 2013 5:34 PM by Son Stegmaier

    Showing 0 instead of Blank

    Rudra Pratap

      Hi,

          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.

       

        

      NameStatusDate
      RudraIn3/3/13
      RudraIn3/4/13
      AmitOut4/3/13
      DanielIn 3/8/13
      DanielOut3/10/13

       

      In the report I have a filter named Month and two boxes as shown below.

       

      Month : March

       

      INOUT
      21

       

      Month : April

       

      INOUT

      1

       

      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!!!

       

      Regards,

      Rudra