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!
Formula for "start of week, 10 weeks ago", so that I only have full weeks in our analytics report.
Formula needed for "start of week, 10 weeks ago", so that I only have full weeks in our analytics report.
My Dataset has:
STEP A: set the dataset to get records from any date BEFORE the start of this week, that gets rid of the partial week that I'm in when viewing the report. That takes care of one end of the dataset.
The problem is on the older end of the dataset. I want it to be the start of the week 10 weeks before the end date defined in STEP A. So, then all 10 weeks are full weeks and nothing is a partial week on either end.