I'm creating a product report that should only display records where the product quantities (including any on order) is greater than 0. So basically the sum of 2 fields > 0.
My record selection formula looks like this (not exact field names but you get the idea):
(STOCK.QTY + STOCK.QTY_ON_ORDER) > 0
however when I view the SQL query it seems to be completely ignoring this formula
Am I doing something wrong?