Count empty space in a column

[#1]

Good Morning!

How do I count the "ISSUED" Status, when in the Delayed column has the field blank. In this case the count is "6".

[tajmohamed30]

Hi,

Have you tried this,

=count(IsNull(Delayed)) or

=NullCount(Delayed)

Thanks

Taj Mohamed

[felipedl]

You could use set analysis to count the ones that don't have value.

Like this:

count({<Delayed={""}>}Status)

Regards,

Felipe.

[#4]

Good morning!

Did not work. I need you to count nulls in the Delayed column, only when the Status column has the ISSUED option

Status

Delayed

ISSUED

ISSUED

SAFETY

ISSUED

INPRG

ISSUED

ISSUED

CUSTOMER

ISSUED

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

SAFETY

ISSUED

CUSTOMER

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

CUSTOMER

ISSUED

MATERIAL

[#5]

Good morning!

Did not work. I need you to count nulls in the Delayed column, only when the Status column has the ISSUED option

Status

Delayed

ISSUED

ISSUED

SAFETY

ISSUED

INPRG

ISSUED

ISSUED

CUSTOMER

ISSUED

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

SAFETY

ISSUED

CUSTOMER

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

MATERIAL

ISSUED

CUSTOMER

ISSUED

MATERIAL

[felipedl]

Just add another clause to the set analysis.

count({<Status={"ISSUED"},Delayed={""}>}Status)

Regards,

Felipe.

[#7]

Did not work! Counting with this expression gives "Zero"

[felipedl]

Hi, attached a QVW with an example

Hope it helps.

Felipe.

[ahaahaaha]

Hi,

May be like this (look attached file)

RangeSum(Above(Count({<Delayed={"=Len(Delayed)=0"}>}Delayed), 0, ROWNO(TOTAL)))

Regards,

Andrey