Count where field is not null

[#1]

Dear all,

i want to do a numeric count of data that field DATA is null, but i don't know how to do that

numericcount({$<[DATA]=NULL}>} [DELIVERIES])

Can someone explain me how to do that.

Best regards

[Miguel_Angel_Baeyens]

Hello Jordi,

You may use

numericcount({$<[DATA]={""}>} [DELIVERIES])

numericcount({$<[DATA]={"=len([DATA]) = 0"}>} [DELIVERIES])

Hope that helps

[sparur]

Hello, Jordi

Try that:

=count(IF(Len(DATA)>0, [DELIVERIES]))

[#4]

No ones work

[sparur]

Jordi, it's very strange.

because all approaches are works fine for me. see in example...