Set Analysis - multiple conditions on the same variable

[#1]

Hello Everyone,

I have the following statement currently:

=COUNT({<NON_COMPANY={'Other'}, NO_COMPANY_KEYWORD=>} UID)

I have the

NO_COMPANY_KEYWORD=

because I want the chart to act independently of the listbox, however I also want to do put in a condition that says 'exclude all that are null' which I would normally do as the following:

NO_COMPANY_KEYWORD-={''}

, however I'm not sure how to combine these two. Is it possible without explicitly listing my keywords?

Thanks

Gareth

[Miguel_Angel_Baeyens]

Hello Gareth,

Try the following

=COUNT({<NON_COMPANY={'Other'}, NO_COMPANY_KEYWORD=> - < NO_COMPANY_KEYWORD -= P(NO_COMPANY_KEYWORD ) >} UID)

Hope that helps