% Change

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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

[#3]

OMG that is genius!!!