any idea why this formula wouldn't work? - CASE WHEN ({transferorderquantityshipped}-{transferorderquantityreceived}) = > 0 THEN ({transferorderquantityshipped}-{transferorderquantityreceived}) ELSE {quantity} END I'm trying to get the quantity value only if there isn't a value already for shipped-received else give me that value... all help welcome

=> is wrong. You want >=

You probably also need to wrap most of the quantities in nvl({field},0)