Expression in a chart

[alec1982]

Hi,

I am trying to write script for an expression..

I need the count a field where it is not null.

Thxs for your help,

[Anonymous]

try this this may help you

COUNT({<field-={""}>} field ID))

[alec1982]

Thxs but i got a little confused..

If the field name is XYZ so how it should be?

Thxs

[chematos]

COUNT({<XYZ-={""}>}distinct XYZ))

[alec1982]

I have tried :  = COUNT({<[Expiration Date]-={""}>}[Expiration Date]))

and i am getting a red line under the dash before the equal sign!

Any advice?

Thxs,

[chematos]

Try it although the red line, it must work, I had the same problem before but it works

[#7]

Yes it will work .

sure ignore red line.