Count if Sum greater than

[michak80]

Hello, 

I have following data 

Count({<ORDER_ID = {"T*"}, LIST_ID ={"0*"}>}distinct ORDER_ID) - so,it's mean I recived all orders which starting from T and list id starting from 0. 

I need to add new requirment:  ... and if sum in column QUANTITY >= 10 

Could you please help me? 

[tresesco · Accepted solution]

Try like:

Count({<ORDER_ID={"=Sum(QUANTITY)>=10"}, ORDER_ID = {"T*"}, LIST_ID ={"0*"}>}distinct ORDER_ID)

[michak80]

Hello @tresesco 

thank you for quick reply. Unfortunatly it's doesn't work. I recieve the same quantity as for below

Count({<ORDER_ID = {"T*"}, LIST_ID ={"0*"}>}distinct ORDER_ID)

[michak80]

Hello, 

maybe someone has another idea? Thanks in advance. 

[tresesco]

The issue could be with your data model or the way you are trying. Try to share a sample app to work on.