sum the revenue by every 3 months?
I need to sum the revenue by every 3 months and want this to be automatically updated in the dashboard. For instance, if It's august I need to see the revenue of May + June + July. When august ends need to see the sum of June + July + August and how to do this. Can anyone please help?
Best Answers

If you change the months to numbers (January is 1, February is 2) I came up with this.
=SUM(INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY())  1, months:months, 0)), INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY())  2, months:months, 0)), INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY())  3, months:months, 0)))
Perhaps there's an easier way to do it but this works.
It basically is getting Today's current month and subtracting 1 (previous month), then subtract 2 (2 months ago), then subtract 3 (3 months ago) and pulling the numbers from the revenue column and adding them.
Hope this helps.

@Ozu If you added a new column called "Month" then you will need to replace the "Months" to "Month" in the formula or whatever the name you are using for that column.

@Ozu you put MONTH())2 you forgot to put MONTH(TODAY())2
Answers

If you change the months to numbers (January is 1, February is 2) I came up with this.
=SUM(INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY())  1, months:months, 0)), INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY())  2, months:months, 0)), INDEX([Sales Net Revenue]:[Sales Net Revenue], MATCH(MONTH(TODAY())  3, months:months, 0)))
Perhaps there's an easier way to do it but this works.
It basically is getting Today's current month and subtracting 1 (previous month), then subtract 2 (2 months ago), then subtract 3 (3 months ago) and pulling the numbers from the revenue column and adding them.
Hope this helps.

Thanks for all the help Michael, let me try. I think it will work.

I am getting #UNPARSEABLE error, can you please check what I have entered wrong?

@Ozu If you added a new column called "Month" then you will need to replace the "Months" to "Month" in the formula or whatever the name you are using for that column.

@Ozu you put MONTH())2 you forgot to put MONTH(TODAY())2
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!