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

    % Chg between 2 periods or values

    Don Barnetson



      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.