Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Year | RIDDOR | FinalHeadCount | Incidence Rate |
2011 | 39 | 3151 | 1,238 |
2012 | 34 | 3141 | 1,082 |
Hi Melanie,
Try with the following as a new expression (the first row will be null, as long as there are no years to compare with):
Column(3) / Above(Column(3))
Hope that helps.
Miguel
Hi Melanie,
Try with the following as a new expression (the first row will be null, as long as there are no years to compare with):
Column(3) / Above(Column(3))
Hope that helps.
Miguel
OMG that is genius!!!