Not equal to in Set analysis

[markgraham123]

Hi all,

I'm writing a set analysis expression,

Count(DISTINCT( Places))

Here i wanna omit the places which has flag "1" .

"Cross" and "Hill" has the flag "1" during the script execution with a condition.

Finally, i'm trying to get Count(DISTINCT( Places)) where flag for Cross and Flag is not equal to "1" (or equal to "0")

[ramoncova06 · Accepted solution]

you can use -= to exclude a value

Count({<flag -={1}>} DISTINCT Places)

[markgraham123]

Thanq Ramon.