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

    % Change



      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