CASE WHEN {transaction.mainline} = 'T' AND {type} IN ('Sales Order') AND {trandate} between to_date('12monthsago', 'DD/MM/YYYY') and to_date('today', 'DD/MM/YYYY') THEN {transaction.amountnetoftax} ELSE 0 END