Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to convert this if condition to set analysis.
if(Status='arias' and (Count( Status ) >1) ,Count ( DISTINCT Fac_no ))
thanks
Savi.
sorry
count({<Status={'arias'},Count( Status ) ={">1"}>} DISTINCT Fac_no )
or
aggr(count({<Status={'arias'},Count( Status ) ={">1"}>} DISTINCT Fac_no ),Fac_no )
hope this helps
count({<Status={'arias'},Count( Status ) >1>} DISTINCT Fac_no )
or
aggr(count({<Status={'arias'},Count( Status ) >1>} DISTINCT Fac_no ),Fac_no )
hope this helps
hi Sunil,
thanx Sunil. but this is not working , there is a mistake. can u fix it.
thanx
Savi.
sorry
count({<Status={'arias'},Count( Status ) ={">1"}>} DISTINCT Fac_no )
or
aggr(count({<Status={'arias'},Count( Status ) ={">1"}>} DISTINCT Fac_no ),Fac_no )
hope this helps
hi Sunil,
there is a mistake, can u check if u dont mind.
thanx Savi.
Looking at the two bits of code (IF and Set Analysis) it would appear these will give different results. In the instance with the IF statement a count of all Fac_no's will be given if any Status is greater than one. In the set analysis example a count of Fac_no's where the status is greater than one will be given.
The later sounds more useful, but it is a different result.
- Steve
it s better you can upload a sample file.
Hi,
Check with this
Count ( {<Status={'arias'}>*<Status={"=Count(Status)>1"}>}DISTINCT Fac_no )
Celambarasan