Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
may be like:
=count({<ordered={'*'}-{'0'}>} disctinct ordered)
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
=count({<ordered-={'0'}>} DISTINCT ordered)
null as a text in your field?? if yes, may be this:
=count({<ordered={'*'}-{'0','null'}>} disctinct ordered)
maybe this
=count({<ordered={'*'}-{''}>} disctinct ordered)
Hi,
Please try
=count({<ordered -= {'0'}>} ordered)