AnsweredAssumed Answered

Dynamic figures by year calculation

Question asked by mgxdigital on May 4, 2009
Latest reply on May 7, 2009 by mrvodka


Dynamic figures by year calculation


Hello All,

I am trying to do comparisons of sales between a month and the previous year's same month.

So say this month so far, i have $50,000 in sales, I want to compare that to May 2008 sales.


I have the dates down. I can show this month and i can show all of the previous year month.

The problem that I am running into is making the previous year month dynamic as the current month is.


This is how my calc work now.

This May 2009 so far i have $50,000 in sales, May 2008 it will show $250,000 in sales.

It is showing the entire past month, not keeping it up to date with where we currently are in the current month.


I would like it to show this month's sales up until today and the previous years month up until the current date.

May 4th 2009 - $50,000

May 4th 2008 - $48,000


This way we can see how the month is going without having to wait until the end of the month to compare figures.

Please help!