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!
Saved Search - Grouping Transactions by Quarters Over Multiple Fiscal Years (not Calendar Year)
Hi there,
I’m struggling on one formula. I have a saved search that’s date range is 4 quarters ago to date… so basically showing me up to 5 quarters. I want to group it by quarter and I want to do it dynamically, meaning nothing is hardcoded. I want it to display 2019-Q1, 2019-Q2, etc. I have done tons of searches, and I see a lot where you can do it based on month, but because I’m spanning across different fiscals, it doesn’t accurately display my quarters (e.g. right now, it will show 2019-Q1, and 2020-Q1, but its displaying incorrect data -