How to write expression in chart?

[#1]

Hi,

I have to write expression  when

Progress <>'In', 'Out', 'Delete '  then count of ID

can anyone suggest me please.

Thanks.

[sunny_talwar]

Try something like this:

=Count({<Progress = e({<Progress = {'In', 'Out', 'Delete'}>})>} ID)

you might need a DISTINCT if you only want to count the unique instances.

HTH

Best,

S

[amit_saini]

Hi,

Try something similar:

count(distinct if(filedname<>0, UserID)

or

count(distinct if(UserID<>0, UserID)

or

count({$<UserID-= {'0'}>} distinct UserID)

Thanks,

AS

[MK_QSL · Accepted solution]

=COUNT({<Progress -= {'In','Out','Delete'}>}DISTINCT ID)

[amit_saini]

Try this:

count({$<Progress-= {'In', 'Out', 'Delete'}>} distinct ID)

Thanks,
AS

[#6]

Thanks for all answers

[mukesh24]

Hi,

=COUNT({<Progress -= {'In','Out','Delete'}>}DISTINCT ID)

=count(if(not wildmatch(Progress,'In','Out','Delete'),ID)

Regards,

Mukesh

[#8]

Hi,

Try this.

=Count({$<FieldName = e({$<Progress = {'In', 'Out', 'Delete'}>})>} ID)