Set Analysis Operator

[marco_puccetti]

Hello i need an operator used to count element not ugual to a certain condition like this it doesn't work:

=Count({<STATO<>{'SCADUTA'},STATO<>{'ATTIVATA'}> }DISTINCT NUMERO_PROPOSTA)

How can be made without using the <> operator?

Thanks

Marco

[giakoum]

replace <> with -=

[giakoum]

=Count({<STATO-={'SCADUTA','ATTIVATA'}> }DISTINCT NUMERO_PROPOSTA)

[sunny_talwar]

or this should also work for you

=Count({<STATO = e({<STATO = {'SCADUTA','ATTIVATA'}>})>} DISTINCT NUMERO_PROPOSTA)

[johngouws]

Hi there Marco,

try:

=Count({<STATO += {'SCADUTA'},STATO += {'ATTIVATA'}> }DISTINCT NUMERO_PROPOSTA)

You will get a red underline but it is ok.

[giakoum]

Marco is asking for not equal

[johngouws]

Hi Marco,

Sorry it is -= NOT +=

[marco_puccetti]

Ok

Thanks

Marco