Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to calculate last year YTD?
Hi all,
I have a question on Previous Year YTD calculation.
I tried different function but still failed to get the result.
I used the below formula in my analysis:
✅Previous MTD = AGO( Sales, MONTH, 1 )
✅Current YTD = TODATE ( Current MTD , Year )
❌Previous YTD Try 1 = AGO( Current YTD , Year, 1 )
❌Previous YTD Try 2 = TODATE( AGO( Sales, Year, 1), Year)
❌Previous YTD Try 3 = AGO( TODATE( Sales, Year ), Year, 1 )
Please suggest a proper way to calculate the previous year YTD. Thanks in advance!
Regards,
Ivan