```DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandat...
# generalj
jen
12/06/2019, 12:01 AM Copy code
DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),0,{quantity})jen
12/06/2019, 12:01 AMDECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),0,{quantity})