1 Reply Latest reply on May 13, 2014 9:04 AM by Don Barnetson

    % Chg between 2 periods or values

    Don Barnetson

      Hi,

       

      I'm sure this is a simple formula, but for some reason I am stumped today. Currently I'm using a formula for % Chg that calculates the difference between 2 specific dates:

       

      sum( [sales 2012] ) / sum( [sales 2011] ) -1     then change the Field Property/Number to %

       

      I need it to be more dynamic. I'm working with several years of data, so I require it to function for multiple values

      showing the difference between each year for each Dimension.

       

      Thanks,
      Don