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).




      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:




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

      Any help would be appreciated.