Null Values Not Showing

[#1]

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!

[whiteline · Accepted solution]

Ok,

Have you unchecked the checkbox 'Supress Zero-Values' on Presentation tab ?

[#3]

Ha wow. That was ridiculously obvious. Thank you, whiteline and Mayil.