Count data exclude values greater than less than

[jade]

Hi guys! I need your help regarding this. So, I want to count only the data of the Pending ID Projects where I need to exclude only the Pencil and Paper that are less than $25M. I want to see only the count of all Flags that are more than $25 except for the Pencil and Paper which are less than $25M.

[PrashantSangle]

Considering you want to count ID_Project not flag

Try below 2 ways

1:

Count({<Amount={"> 2500000"},Flag-={'Pencil','Paper'}>}ID_Project)

+

Count({<Amount={"< 2500000"},Flag={'Pencil','Paper'}>}ID_Project)

2:

Count({<Amount={"< 2500000"},Flag={'Pencil','Paper'}>+<Amount={"> 2500000"},Flag-={'Pencil','Paper'}>}ID_Project)

Regards,

Prashant Sangle

[jade]

It is also limited to Pending Status. This is for the KPI by the way

[PrashantSangle · Accepted solution]

add that flag too in set analysis

Count({<status={'Pending'}, Amount={"< 2500000"}, Flag={'Pencil','Paper'}>+<status={'Pending'}, Amount={"> 2500000"}, Flag-={'Pencil','Paper'}>}ID_Project)

or 

{<status={'Pending'}>}Count({<Amount={"< 2500000"}, Flag={'Pencil','Paper'}>+<Amount={"> 2500000"}, Flag-={'Pencil','Paper'}>}ID_Project)

Regards,

Prashant Sangle