CASE WHEN {transaction.mainline} = '*' AND {transaction.type} = 'Invoice' AND {transaction.trandate} BETWEEN ADD_MONTHS(TO_DATE(SYSDATE, -12), 'DD/MM/YYYY')) AND TO_DATE(SYSDATE, 'DD/MM/YYYY') THEN NVL({transaction.netamountnotax},0) ELSE 0 END