Need Help

[paulwalker]

Hi Community,

I have one issue on Null values, i have to show null records in my Chart....

I am using Gantt chart..

My requirement is if EndDate=StartDate=Null  then i want show symbol in Chart...

By default it showing Null values, if i am using this condition

Year([Site StartDate]) <=2018    its excluding Null values..

anything wrong here???

See this one particular case AO1EIK    

Thanks in Advance

[Mark_Little]

Hi,

I am not a hundred percent sure what you are trying achive, But the condition would cause them to disappear and the fail it. Year([Site StartDate]) <=2018 .

Not always the best approach, but could you do something like

If(ISNULL(Field),'Value',

    IF(Year([Site StartDate]) <=2018,'Your Expression' )

    )

Mark

[paulwalker]

I need data only up to 2018 years records only...

if i have any null values i want to show symbol in my chart

[sunny_talwar]

See this one particular case AO1EIK

I don't see anything attach, did you mean to attach something with the post?

Year([Site StartDate]) <=2018    its excluding Null values..

Try this may:

Where Year([Site StartDate]) <= 2018 or Len(Trim([Site StartDate])) = 0;

[paulwalker]

Thanks Sunny ..!!!!

I got it   .....