Not Equal to checking in Set Analysis

[#1]

Hi

Usually we use equal to in set analysis.

in my case

Status column =0 or 1 or anything (based on data)

I want to have all prioduct sales whose status <> 0 and ID=1

What is the syntax for that?

[gandalfgray · Accepted solution]

it would be something like:

sum( {<status-={0}, ID={1}>} sales)

note the -= for status

[#3]

and additional info ;

*if you use "-" before "=" like that sum( {<status-={0}, ID={1}>} sales) result will effect your choise

*if you use "-" after "=" like that sum( {<status=-{0}, ID={1}>} sales) result will not effect your choise ...

[#4]

Thanks It worked the way I want...

And aso could you tell me how to check not null values... (like this -=null())