Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Gareth,
Try the following
=COUNT({<NON_COMPANY={'Other'}, NO_COMPANY_KEYWORD=> - < NO_COMPANY_KEYWORD -= P(NO_COMPANY_KEYWORD ) >} UID)
Hope that helps