7 Replies Latest reply: Sep 27, 2016 1:52 PM by Rohit Kumar RSS

    Display value for null

    Ugonna Okoli

      Hi all,

       

      Is it possible to display N for null values in a dimension?

       

      I have a field(List) with Y and null values, on the front end I'd like to display the null values as N in a straight table, the expression if(IsNull(List),'N',List) works correctly when used as a measure however I need the column to be a dimension to allow users select values.

       

      Any thoughts?

      Capture.PNG

       

      Thanks