CASE WHEN {transaction.mainline} IN '*' 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.netamountnotax},0) ELSE 0 END