AnsweredAssumed Answered

# Dynamic figures by year calculation

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

### Title

Dynamic figures by year calculation

### Post

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!

Thanks!