Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
May be NullCount(ST) will count Nulls in ST?
i have tried the below one but it is not working
count(distinct{$<KomDaten={"*ABC*"},
Build_type={'old'},
ELF-={'Planung'},
nullcount(St)
>}Link_Rev)
I meant like this
Count(DISTINCT {$<KomDaten={"*ABC*"}, Build_type={'old'}, ELF-={'Planung'}>}Link_Rev) + NullCount(St)
Unfortunately it is not working.
Thanks for the support.
I hope you might have some other tips for me.
Do you have a sample you can share to help you better?
Try this:
Count(DISTINCT {$<KomDaten={"*ABC*"}, Build_type={'old'}, ELF-={'Planung'}, len(St)=0 >}Link_Rev)
Sachin
It is also not helping me out as the expression is showing error.