Do you mean you want the count of produces with "new" and "hidden" plus the count of products with "carryover" and "hidden"?
You'd need to either use ExecuteSQL to produce that count or add a calculation field to the Products table:
Call it cHiddenAnd:
(ProductStatus = "new" or ProductStatus = "CarryOver" ) and ImageStatus = "Hidden"
Select a Number result type.
Then: Sum ( Products::cHiddenAnd )
will return the count that you want.
Thanks for the reply, but I am still not quite getting the results I need. I tried adding the calculations to both Projects and Product tables, but I am looking to count the Projects children from Products table.
Actually, working fine once I tried putting the countSum into the products table... Must've done something wrong the first time around. Thank you very much!