CASE WHEN (({trandate} > (CURRENT_DATE - 8)) AND ({trandate} <= (CURRENT_DATE - 1))) THEN ({transactionlines.quantity} * -1) ELSE 0 END