Set Analysis and Selection form list box

[shane_spencer]

I've got an issue with Set Analysis. I've got a formula in a text box to count Status and Manual Status, but I've also got these as selections in list boxes. The issue is if I select Confirmed from Manual Status for example the figures circled in the text box should show 0 but are showing the total count. Is there an easy way to fix this?

[Chanty4u]

not clear   what it is text box expression?

[sunny_talwar · Accepted solution]

Try this and also read about the use of * here Implicit Set Operators

=Count( {< Status *= {'Pass'} >} Row) & ' Pass and ' &

Count( {< Status *= {'Review'} >} Row)  & ' Review  |  ' &

Count( {< [Manual Status] *= {'Verified'} >} Row) & ' Verified, ' &

Count( {< [Manual Status] *= {'Confirmed'} >} Row) & ' Confirmed, ' &

Count( {< [Manual Status] *= {'Unconfirmed'} >} Row) & ' Unconfirmed and ' &

Count( {< [Manual Status] *= {'Corrected'} >} Row)  & ' Corrected'

or this

=Count( {< Status = {'Pass'} >} Row) & ' Pass and ' &

Count( {< Status = {'Review'} >} Row)  & ' Review  |  ' &

Count( {< [Manual Status] *= {'Verified'} >} Row) & ' Verified, ' &

Count( {< [Manual Status] *= {'Confirmed'} >} Row) & ' Confirmed, ' &

Count( {< [Manual Status] *= {'Unconfirmed'} >} Row) & ' Unconfirmed and ' &

Count( {< [Manual Status] *= {'Corrected'} >} Row)  & ' Corrected'

[shane_spencer]

Thanks Sunny! And thanks again for the link, I've only used the Implicit Exclusion before.