Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
DECODE(TO_CHAR formular - Need a column that the total quantity sold for the past 12 months
Answer Id: 23079
I have followed this answer ID - which is great - note that I have modified it - so when downloaded to excel I do not have blank fields in the quantity as excel can't do formulars on blank fields easily. So it really should have NVL function around it.
NVL(DECODE(TO_CHAR({today},'MM') - TO_CHAR({trandate},'MM') + 12*(TO_CHAR({today},'YYYY')-TO_CHAR({trandate},'YYYY')),0,{quantity}),0)
These formulas are populating one month in each column for the prior 12 months.
But now i want a formula that adds up the last 12 months and I can't work out how to do that. I would suggest this answer ID should be updated to put that formular in once it is determined!
1