Set Analisys Modifier

[#1]

Hi all

with Rel 8.5 this expression was marked as OK

Count(distinct {$<DOCLIE={'000000'}>} DOKSCL) and works well

-------

while with Rel 9.0

is marked as "Error in Expression" when I try to change it and

the column show an empty value

Someone know why ???

Many Thanks

Claudio

[#2 · Accepted solution]

Hi Claudio, try with tis:

Count

({$ <DOCLIE={'000000'}> }DISTINCT DOKSCL )

Regards

[#3]

Hi ,

many thanks for your answer.

Now it works wll with the '=" sign.

If i have to compare where the field DOCLIE is greater than (using always >) it doesn't work

count ({$ <DOCLIE>{'000000'}> }DISTINCT DOKSCL )

Thanks again

[#4]

Try:

count ({$ <DOCLIE = {'>000000'}> }DISTINCT DOKSCL )

[#5]

Hello!

I'm sorry for my English but I'm French and not verry good in English!

I want to know how do <> in set analysis. For example, Count({$<DOCLIE<> {'000000'}>}distinct DOKSCL) .

I want do a different, but I don't arrive to do.

Anyone can help me? Thank you very much for your help!

[#6]

I believe that would be:

Count({$<DOCLIE -= {'000000'}>}distinct DOKSCL)

The -= symbol is the exclusion. Meaning you would get everything except DOCLIE = '000000'.

[#7]

Thank you very much! You are my Hero!! Good Day!