Count Blank fields in an expression

[sabrina87]

Hi all,

I am trying to count in an expresion when it meets 2 conditions but it is not working, could you help me?

It should count when the field compliant is No and Label is blank

count({<[compliant]={'No'},'LEN(TRIM(LABEL))=0'>} [compliant])

Thanks in advance!

[edwin · Accepted solution]

try 

count({<[compliant]={'No'},LABEL={"*"}-{''}>} [compliant])

[edwin]

{"*"} means NONE NULL values
-{''} means exclude blanks

[edwin]

i read it the other way, if you are looking for just blanks (NOT NULL - there's a difference)

count({<[compliant]={'No'},LABEL={''}>} [compliant])

[edwin]

if you are looking for NULL:

{<complaint={'No'}>-<complaint={'No'}, LABEL={"*"}>}

get everything with complaint=No less those with a Label