1 Reply Latest reply on Jul 15, 2016 8:13 PM by Dmitry Chirkov

    Trying to get missing data text to show up as 0

    Matt Hong

      I have categorical data and I'm trying to show percent of total for a category as text:

       

      Below, I want to show percent of 1s specifically (the other rows are typically hidden, but unhidden here for illustration).

      help3.PNG

       

       

      Toward this goal I am using a calculated field with formula:

       

      zn(SUM(if [Q1a] == 1 then [Number of Records] end) / TOTAL(SUM([Number of Records])))
      

       

       

       

      My issue is that when there are no rows with 1s in the relevant column, text is entirely missing as opposed to showing 0:

      help4.PNG

       

       

      This is especially weird since the ZN() function seems to work for other values and shows 0.0%.

      Any help would be appreciated.