11 Replies Latest reply: Sep 24, 2012 12:03 PM by Rebecca Molstad RSS

    Null Values Not Showing

    Rebecca Molstad

      Hi All,

       

      I have a question that should be obvious, but nothing seems to work.  I have a straight table with the following dimensions:

       

      Project_ID

      Title

      CategoryDesc

      Manager

      Status

      =Date(Start_Time,'MM/DD/YYYY')

      =Date(End_Time,'MM/DD/YYYY')

       

      And the following expression:

       

      =Date(End_Time,'MM/DD/YYYY')-Date(Start_Time,'MM/DD/YYYY')

       

      However, there are values in my chart in which start time and end time are null, and these do not show up in the graph.  Suppress Null values is not selected on any of the dimensions. I need all the values to show up, even when there is no start or end time. I tried this for the expression, but it did not work either:

       

      =if(IsNull(Start_Time)=-1,'0',Date(End_Time,'MM/DD/YYYY')-Date(Start_Time,'MM/DD/YYYY'))

       

      If I add another expression like this, all the data shows up:

       

      =If(IsNull(Start_Time)=-1,'Null','Not Null')

       

      Thanks for your help!