topic Re: Count Blanks and Non-Blanks in App Development

Count Blanks and Non-Blanks

leobhavin — Thu, 13 Sep 2018 13:51:33 GMT

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.

Re: Count Blanks and Non-Blanks

jwjackso — Thu, 13 Sep 2018 15:29:13 GMT

Ignore 'PASS' and count the rest using -=

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

Re: Count Blanks and Non-Blanks

leobhavin — Thu, 13 Sep 2018 15:30:54 GMT

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

Re: Count Blanks and Non-Blanks

jwjackso — Thu, 13 Sep 2018 15:38:11 GMT

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

Re: Count Blanks and Non-Blanks

leobhavin — Thu, 13 Sep 2018 15:39:32 GMT

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

Re: Count Blanks and Non-Blanks

jwjackso — Thu, 13 Sep 2018 15:49:12 GMT

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