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!
Previous Year Comparisons (by week)
Has anyone being able to put together a search with shows the weekly sales in sequential columns.
I need to display the following:
This Week | Last Week | Same Week last Year
I have used the following formula for the first two:
decode(to_char({trandate},'IW'), to_char({today},'IW'), {netamount}, 0)
and
decode(to_char({trandate},'IW'), to_char({today},'IW')-1, {netamount}, 0)
But, getting This Week last Year is proving to be more complex, as it has the same week number - and whilst I can compare years, I'm concerned that this will return incorrect figures for any week which spans two years.