5 Replies Latest reply: Jan 16, 2018 6:53 AM by Baarathi V

# How to exclude a range of values

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

• ###### Re: How to exclude a range of values

Try this:

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

• ###### Re: How to exclude a range of values

Hi,

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

• ###### Re: How to exclude a range of values

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.

• ###### Re: How to exclude a range of values

yes, try it urself

• ###### Re: How to exclude a range of values

try with below

A

0001

111

222

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

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

];

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