Hello all,
I am a CR "newbie."
I've created a report in which I would like to see the "Percent Change" for a year's value against the previous year's value.
The dataset is limited by a parameter that provides for the "YearOf" value.
My first level grouping is by the Incident Type field ({IncidClo.IncidType})
My second level grouping is by the Year of field ({IncidClo.YearOf})
Under the second level grouping I have a summary:distinct count on a "serial number" {IncidClo.DACCallNum}
So... Incident Type is listed... and under each Incident Type, each year is listed... and for each year there is a distinct count of DAC numbers. (I have to use a distinct count on DACs because they are listed elsewhere in the dataset multiple times as the "DAC's" status changes.)
I want to calculate percent change for the DAC counts for the queried year, relative to the previous year. I'm simply at a loss on how to do so.
Thank you,
Oda
I am a CR "newbie."
I've created a report in which I would like to see the "Percent Change" for a year's value against the previous year's value.
The dataset is limited by a parameter that provides for the "YearOf" value.
My first level grouping is by the Incident Type field ({IncidClo.IncidType})
My second level grouping is by the Year of field ({IncidClo.YearOf})
Under the second level grouping I have a summary:distinct count on a "serial number" {IncidClo.DACCallNum}
So... Incident Type is listed... and under each Incident Type, each year is listed... and for each year there is a distinct count of DAC numbers. (I have to use a distinct count on DACs because they are listed elsewhere in the dataset multiple times as the "DAC's" status changes.)
I want to calculate percent change for the DAC counts for the queried year, relative to the previous year. I'm simply at a loss on how to do so.
Thank you,
Oda
