Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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'
not clear what it is text box expression?
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'
Thanks Sunny! And thanks again for the link, I've only used the Implicit Exclusion before.