Count Blanks and Non-Blanks

[leobhavin]

I have a table with fields called, "Priority", "Status" and "Response SLA".

Values under:

Priority = Emergency, Urgent , Routine, N/A

Status = Resolved, Closed, Inprog

Response SLA = Pass, Fail, (BLANK)

I am using the following formula:

count({<[Response Measure Result]={'FAIL'},[Customer Priority]={'EMERGENCY','EMERGENCY (OOH)','URGENT','ROUTINE'}>}[Work Order])

In the above formula, I want to also count the number of "blanks" under Response SLA with the other parameters remaining same. When I put, '' after Fail it does not work. Can you assist.

[jwjackso]

Ignore 'PASS' and count the rest using -=

count({<[Response Measure Result]-={'PASS'},[Customer Priority]={'EMERGENCY','EMERGENCY (OOH)','URGENT','ROUTINE'}>}[Work Order])

[leobhavin]

Hi...There are blanks too. Would your formula count the blanks. When I say blanks there is no data in the field

[jwjackso]

It should count every row where [Response Measure Result] is not equal to 'PASS'.

[leobhavin]

Sorry but your formula does not count the blanks or empty cells.

[jwjackso]

What does your data look like when the [Response Measure Result] is a blank or empty?