Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a chart with the following expression:
count(distinct{$ <SASTATUS.SA_STATUS_DESCRIPTION = {'Closed'},
SATYPE.CATEGORY = {'Domestic'},
PREM.REG_STATUS = {'N'},
PREM.ENER_FLG = {'D'}>}MPRN.MPRN)
However, there is someone with more than one SA_STATUS_DESCRIPTION (he has one of Combined as well as Closed.)
My question is why is he not excluded? Does he need to meet SOME of the conditions or ALL of the conditions?
If it is searching for people that meet SOME of the conditions, then why are people with more than one
SATYPE.CATEGORY not appearing (for example).Is there an order that needs to be applied?
Any advice gratefully received.
Thanks
Rachael
The data needs to meet all your conditions (it works like AND).
The order of the conditions is not important (in this case at least).
If "someone" has several SASTATUS.SA_STATUS_DESCRIPTION
what you get using your set statement is the records matching "Closed"
(and all of your other conditions)
Try it .i don't know this is correct or not
count(distinct{$ <SASTATUS.SA_STATUS_DESCRIPTION = {'Closed'},
SATYPE.CATEGORY = {'Domestic','International'},
PREM.REG_STATUS = {'N'},
PREM.ENER_FLG = {'D'}>}MPRN.MPRN)
Hi,
look in the helpfile for Set analysis and here for the operators +, -, * and /. You can combine your selections by adding conditions.