Counting Results(solved)

[tsmakrakis]

I have the below table, I need to count the quantity of red bags sold.
How do I do that, I did:

Do a search on SOLD-BAGS:count table with constraint:

Type=Red Bag but I only get 2
Also did same search with SOLD-BAGS’sQty:count with same constraint and get again 2

What is the right expression please?

[lester]

You did you search and constraint right, you need to at the end search select the `QTY field then use sum, also this needs to be a number field for this to work.

Lester

[tsmakrakis]

Thanks…it worked!