How to exclude a range of values

[baarathi]

= Count({<Amount = {">0"}, A = {"0*"} , A -= {"0000*"}>}Id) , will this method exclude values 0000# and include 0# ?

[YoussefBelloum]

Try this:

=Count( {<Amount = {">0"}, A= {"0*"}-{"0000*"}>}  Id)

[devarasu07]

Hi,

expression looks ok & what is the issue ? can you share the mock data and expected output? Thanks

[vinieme12]

yes, try it urself

[vinieme12]

try with below

LOAD * inline [

A

0001

111

222

00002   <<excluded as per pattern  A -= {"0000*"}

03       <<included as per A = {"0*"}

];

Count({<A = {"0*"} , A -= {"0000*"}>}A)

[baarathi]

I am not getting the desired result, beacuse i want to get the count of id, grouping by id and date(if a same id is present in same date n times it should be considered as 1 count) whereas the same id can be in n different dates, then the count is n.