2 Replies Latest reply: Oct 15, 2012 11:19 AM by melaniehuggins RSS

    % Change

      Afternoon

       

      My next problem to tackle...

       

      I have straight table like the one below, where the RIDDOR is a calculated field from the data loaded in, FinalHeadCount is loaded in from a simple excel spreadsheet and then the incident rate is a calcualtion of the columns. Riddor/FinalHeadCount*100,000

       

      How do I show the % change from 2011 to 2012. Obviously I can do this in excel, but I can't seem to get this to work in QV

       

      YearRIDDORFinalHeadCountIncidence Rate
      20113931511,238
      20123431411,082