Set Analysis Count question

[#1]

Hi, I have an expression like this.

='Total Number of Delivered Assets without CC: ' &  Count( {$<[CCConfirmed]={'N','U'},[CCValid]={'N','U'},[DisplayStatus]={'Completed','Delivered'}>} AssetId )

Currently only the assets with CCConfirmed with 'N' or 'U' and CCValid status of 'N' or 'U' are being counted

Instead I only want to count them if it is either of the condition.

CCConfirmed = 'N' or 'U'

or

CCValid = 'N' or 'U'

Any help will be appreciated. Thanks

[#2]

='Total Number of Delivered Assets without CC: ' &  Count( {$<[CCConfirmed]={'N','U'}>+<[CCValid]={'N','U'},[DisplayStatus]={'Completed','Delivered'}>} AssetId )

[#3]

Hi, thanks for your response. This one is now showing the count for only the first two fields and not considering displaystatus at all.

[#4]

Okay, then try this:

='Total Number of Delivered Assets without CC: ' & 

Count( {$<[CCConfirmed]={'N','U'},[DisplayStatus]={'Completed','Delivered'}

>+<

[CCValid]={'N','U'},[DisplayStatus]={'Completed','Delivered'}>} AssetId )

[#5 · Accepted solution]

Thanks. That worked.