2 Replies Latest reply on Sep 23, 2019 6:32 AM by jane.bugai

    How to covert 0 into empty fields when using Count Distinct Table Calc

    jane.bugai

      Hello Everyone,

       

      Hoping someone can help me with my problem.

       

      I have a list of customer names as a dimension as well as parameter. I also created 2 calculated fields that includes simple if statements to show case ID / avg days if customer parameter equals to customer name.

       

      Then I pulled together a cross tab that shows Distinct Count of case IDs and Avg Days (from if statements) for each client in the list. The idea is that I only want to see values for a client selected in the parameter and not other clients.

       

      It works fine, however, the Count Distinct shows -0- for customers that are not selected (it is not the case for avg days as it shows empty fields). I want my Distinct Count to show empty fields similarly to the avg days. Is there a way to go about it?

       

      Below is the screenshot. I have also attached the workbook.