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!
Assistance with RSUM (Running Sum) on Historical Revenue
Hello,
Currently we use the RSUM function to add a set daily goal "line" and display it on a chart, with $ value being Y Axis, and the Date being the X Axis. We then filter it to see just one month at a time (and 1 month per chart), which allows us to compare to set daily revenue goal line (above) to the daily updating revenue calculation "line" on the same chart.
The above works great for us.
We would like to do the same for the "average daily sales this month, last year" but as a "tile" rather than a chart. We have the hard coded the average daily revenue for each month last year, and have it functioning on a line chart using "Date" as the X Axis on this chart.