Not sure, but unable to upload file. Here is the formula: CASE WHEN ({fulfillingtransaction.trandate}) BETWEEN TO_DATE(ADD_MONTHS(LAST_DAY({today}),-2)+1, 'mm/dd/yyyy') AND TO_DATE(ADD_MONTHS(LAST_DAY({today}),-1), 'mm/dd/yyyy') THEN {fulfillingtransaction.quantity} END