11 Replies Latest reply on Nov 14, 2013 11:13 AM by Joey Chadwick

    I'm comparing prices over a monthly period but would like to use an annual average as the base. How can I do this?

    Joey Chadwick

      More detail:

      I have two sets of prices that I'm trying to compare from January 2012 to August 2013. To standardize the two I'd like to take the average price in 2011; then divide each month's price by 2011's average.

      I would theoretically like to write:

      Rate/'2011 Rate'. and let it calculate each month's rate relative to 2011's average.

      How do I get 2011 rate to just stay as the constant through?

      Thanks,

      Joey