ISNULL() not working in listbox/multibox

[Anonymous]

Hi,

I have a chart where I am using a calculated dimension: : if(isnull(TargetFlag),' null','not null').

This is working fine in the chart as a column, however when i give the same condition in the listbox/multibox it doesn't show me the option 'null'.

Also clicking 'null' in the chart doesn't filter it. Not null works fine. Please advise.

[kaushiknsolanki]

Agree with you.

Regards,

Kaushik Solanki

[Anonymous]

Here you go.

[Anonymous]

Hi Sunny,

Any suggestion?

[sunny_talwar]

Leaving work.... will check this out as soon as I get home

[Anonymous]

Thanks

[#7]

Hi,

if(Len(Date(Doc_Signed,'MM/DD/YYYY'))=0,0,1)

check it here once this calculation  Date(Doc_Signed,'MM/DD/YYYY'))

some times it might convert it as numeric value ,in that case  it will come under always one .