Counting Results(solved)

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?


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.


Thanks…it worked!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.