set analysis ordered count

[stephenedberkg]

i want to calculate the ordered count .

ex:

ordered

0

5

6

8

0

my order count is 3

how to achieve this in set analysis?

[Anonymous · Accepted solution]

may be like:

=count({<ordered={'*'}-{'0'}>} disctinct ordered)

[stephenedberkg]

thanks for your quick reply

its working fine but if my data have null value how to write?

ordered

0

5

6

8

null;

my order count is 3

[#4]

=count({<ordered-={'0'}>} DISTINCT ordered)

[Anonymous]

null as a text in your field?? if yes, may be this:

=count({<ordered={'*'}-{'0','null'}>} disctinct ordered)

[arulsettu]

maybe this

=count({<ordered={'*'}-{''}>} disctinct ordered)

[ashwanin]

Hi,

Please try

=count({<ordered -= {'0'}>}   ordered)