IF Statement for a Dimension in Chart Properties

[Anonymous]

If a value is blank or null return blank...

I have a date 12/31/9999  12:00:00 AM and I would like to say if this date exist return blank for the rows...I cannot get this to work. Help?

Chart Properties>Dimensions>Enable Conditional

=IF(termDt= '12/31/9999 12:00:00 AM' ,null(),termDt) Or

=IF(termDt= '12/31/9999 12:00:00 AM' ,'',termDt)

[hic · Accepted solution]

You should probably do this in the script, e.g

     If(termDt= '12/31/9999 12:00:00 AM' ,null(),termDt) as termDt

HIC

[buzzy996]

i think the problem with date format, can u try some thing like

=IF(termDt= date#(('12/31/9999 12:00:00 AM','the format of required datetime stamp') ,null(),termDt)

[Anonymous]

That worked, is there a way to remove the dash - from the data?

termDt

-

-

-

-

-

-

-

[#5]

Hi,

First condition is correct in dimensions tab.

=If(termDt= '12/31/9999 12:00:00 AM' ,null(),termDt)

[maleksafa]

select your dimension under the dimension tab and click on suppress when value is null

[Anonymous]

Remove the null values----> Presentation tab remove Null Symbol in box. Thank you all for the help