Total Count of null values

[#1]

Hi,

I have a field called closedby, which usually has someones first name entered in there.  However if a call has not been closed this fields shows as NULL.  I want to use a text fields that gives me the full count of all rows that have a closedby showing as NULL.

How would I be able to achieve this?

[whiteline · Accepted solution]

If your NULL is just a string value 'NULL' (not empty value)

you can try somthing like =Count({$<closedby={"NULL"}>} closedby)

Create TextBox and enter this expression in a text field.

In case NULL mean empty values you can use =NullCount(closedby)

[#3]

Thanks Whiteline,  They were empty values therefore I used your last expression and it worked perfectly.