3 Replies Latest reply on Jun 14, 2018 2:28 PM by Joe Oppelt

    0/0 giving Null in Tableau

    Suresh Reddy

      Hi All,

       

      I have one metric which is Monitoring Ratio=    sum(Defects Remediated)  / sum(Defects Identified)

      sum(Defects Remediated)  is 0 and sum(Defects Identified) also 0

      Now the Defect Ratio= 0/0 ..0 by anything should be 0,but the metric giving the Empty value.

       

       

      I should not use IFNULL() or ZN function to replace Null with 0.

      Could any one please help me to get the value 0 when its 0/0 instead of Null without using above functions.

       

      Thanks in Advance.

       

      Thanks,

      Suresh.