( CASE WHEN TO_CHAR({trandate},'MM/YY')=TO_CHAR({today},'MM/YY') THEN {amount} ELSE 0 END ) / ( ( ( CASE WHEN TO_CHAR({trandate},'MM/YY')=TO_CHAR(TO_DATE(ADD_MONTHS({today},-1)),'MM/YY') THEN {amount} ELSE 0 END )+( CASE WHEN TO_CHAR({trandate},'MM/YY')=TO_CHAR(TO_DATE(ADD_MONTHS({today},-2)),'MM/YY') THEN {amount} ELSE 0 END )+( CASE WHEN TO_CHAR({trandate},'MM/YY')=TO_CHAR(TO_DATE(ADD_MONTHS({today},-3)),'MM/YY') THEN {amount} ELSE 0 END ) )/3 )