Set analysis for NA or blank value

[#1]

Hi All,

I want to count Incident No. where RE_NAME is 'NA' or blank:

CODE:

Count

({(<RE_NAME={NA}>+<RE_NAME={' '}>)*(<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>)}INCIDENT_NO

)

[#2]

count(if(RE_NAME = 'NA' or RE_NAME = ' ' and INCIDENT_QUAL_STATUS= 'Resolved' and  CLASS_DESC= 'Incident',[Incident No]))

[#3]

updated code

Count({<RE_NAME={'NA', ' '}>*<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>}INCIDENT_NO)

[#4]

This is not working out!

[#5]

Pls check..

Count({<RE_NAME={'NA',' '},INCIDENT_QUAL_STATUS={'Resolved'},CLASS_DESC={'Incident'}>}INCIDENT_NO)

regards-bika

[#6]

It's working but I want in terms of set expression.

[#7 · Accepted solution]

try this

Count({<RE_NAME={'NA', ''}>*<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>}INCIDENT_NO)

or try this

Count({<RE_NAME={'NA', '-'}>*<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>}INCIDENT_NO)

[Sokkorn]

Hi,

Not sure you have try this yet:

Count({$<[INCIDENT_QUAL_STATUS]={'Resolved'}, CLASS_DESC={'Incident'},[RE_NAME]={'NA'}>+<[RE_NAME]={' '}>} [INCIDENT_NO])

Regards,

Sokkorn