I have a saved ITEM search with the following formula:

Formula(Numeric):

(CASE WHEN SUM(CASE WHEN ({transaction.type} = 'Order Reservation') THEN (CASE WHEN ({transaction.type} = 'Order Reservation' AND {transaction.status} = 'Approved' AND {transaction.saleschannel} = 'DTC') THEN ({transaction.quantitycommitted}-{transaction.quantitydemandallocated}) ELSE 0 END)ELSE 0 END)+ MAX(NVL({locationquantityavailable},0)) +MAX(0) <0 THEN 0 ELSE (SUM(CASE WHEN ({transaction.type} = 'Order Reservation') THEN (CASE WHEN ({transaction.type} = 'Order Reservation' AND {transaction.status} = 'Approved' AND {transaction.saleschannel} = 'DTC') THEN ({transaction.quantitycommitted}-{transaction.quantitydemandallocated}) ELSE 0 END)ELSE 0 END)+ MAX(NVL({locationquantityavailable},0)) +MAX(0)) END)-{custitemdtcavailqty}

Summary type = Maximum

This returns the correct values, so the formula is OK. However, I really only want to see values if they are not equal to zero. When I put this formula in as criteria instead of a result, netsuite gives an error: "