Null Value

[#1]

Dear All,

I am usnig the set analysis and now I am encountering a null problem.

I have multiple search "Count" and also wants to count null values.

count(distinct{$<KomDaten={"*ABC*"},

Build_type={'old'},

ELF-={'Planung'},

isnull St={'*'}

>}Link_Rev)

I am trying to use ther Isnull function but the result is always ZERO.

Please help me in this regard.

Thanks

[sunny_talwar]

Are you trying to ignore selection in St field? May be try this:

Count(DISTINCT {$<KomDaten={"*ABC*"}, Build_type={'old'}, ELF-={'Planung'}, St= >}Link_Rev)

[#3]

Thanks for the quick response but it is not working.

Actually I want to count all the blanks in "ST" but unfortunately the simplest part cannot be solved

[sunny_talwar]

May be NullCount(ST) will count Nulls in ST?

[#5]

i have tried the below one but it is not working

count(distinct{$<KomDaten={"*ABC*"},

Build_type={'old'},

ELF-={'Planung'},

nullcount(St)

>}Link_Rev)

[sunny_talwar]

I meant like this

Count(DISTINCT {$<KomDaten={"*ABC*"}, Build_type={'old'}, ELF-={'Planung'}>}Link_Rev) + NullCount(St)

[#7]

Unfortunately it is not working.

Thanks for the support.

I hope you might have some other tips for me.

[sunny_talwar]

Do you have a sample you can share to help you better?

[sdmech81]

Try this:

Count(DISTINCT {$<KomDaten={"*ABC*"}, Build_type={'old'}, ELF-={'Planung'}, len(St)=0 >}Link_Rev)

Sachin

[#10]

It is also not helping me out as the expression is showing error.