Set Analysis - no equal to does not work

[#1]

Hi,

Please let me know what is wrong with the below syntax:

=count (
{<
[FLAG] = {'I'}, [STATUS] <> {'CIO Review'}
>}
Distinct RAV_CASE_ID
)

Thanks,

Sudha.

[Agis-Kalogiannis]

You cannot use <> in set analysis.

You can do something like

[STATUS] =- {'CIO Review'}

Can you try and let me know?

Thanks

Agis

[#3]

Hi Agis,

Thanks for your help!

Still I am getting some error; not sure what I am missing -

=count (
{<
[FLAG] = {'I'}, [STATUS] =- {'CIO Review'}>}
Distinct RAV_CASE_ID
) 

[Gysbert_Wassenaar]

The syntax checker of the expression editor has a bug that causes it to incorrectly flag the -= construction as a syntax error. It isn't, the syntax checker is in error.

[#5]

Oh Ya!  That's right. It's working fine now.  Thank you

[Agis-Kalogiannis]

Can you please mark one of the answers as helpful or correct so as to close the discussion?

I would appreciate it.

Thanks

Agis