CASE WHEN {transaction.mainline} = 'T' AND {transaction.type} IN ('Invoice') AND {transaction.trandate} between to_date(ADD_MONTHS(TODAY, -12), 'DD/MM/YYYY') and to_date('TODAY', 'DD/MM/YYYY') THEN NVL({transaction.amountnetoftax},'0') ELSE 0 END