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!
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.
0