If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Average rate based on job title

Started by Nickbruno, 18 Jul 2014 10:26:46 AM

Previous topic - Next topic

Nickbruno

I have a list report I'd like to calculate an average rate by job title. For example there will be 10 or 12 job titles (sales rep,tech, etc.) I'd like to figure an average rate of the job title. I'm new to cognos so any assistance would be appreciated. Please let me know if I'm not being clear.

MFGF

Quote from: Nickbruno on 18 Jul 2014 10:26:46 AM
I have a list report I'd like to calculate an average rate by job title. For example there will be 10 or 12 job titles (sales rep,tech, etc.) I'd like to figure an average rate of the job title. I'm new to cognos so any assistance would be appreciated. Please let me know if I'm not being clear.

Hi,

If the list is really simple - just the job title and the rate measure, all you need to do is to drag these two items into the list, then select the Rate column and change the Aggregate Function property to Average.

If your report is more complex, post back with details and we will advise the easiest solution.

Cheers!

MF.
Meep!

Nickbruno

Thank you! There are more fields I will post below. More so there are several employees with the same job description but different wage rates so i need cognos to look at all the employees with a job description of say "analyst" & calculate the avg rate for that job description.

Job Description.    Employee ID.  Department. Hourly Rate
Analyst                        00011          Finance.        10.00.   
Analyst.                       00012.         Finance.        12.00.   
Analyst.                       00013.         Acctn.           10.00
Avg.                                                                    10.67

Thanks!

MFGF

Quote from: Nickbruno on 18 Jul 2014 12:48:51 PM
Thank you! There are more fields I will post below. More so there are several employees with the same job description but different wage rates so i need cognos to look at all the employees with a job description of say "analyst" & calculate the avg rate for that job description.

Job Description.    Employee ID.  Department. Hourly Rate
Analyst                        00011          Finance.        10.00.   
Analyst.                       00012.         Finance.        12.00.   
Analyst.                       00013.         Acctn.           10.00
Avg.                                                                    10.67

Thanks!

Ok - in that case, group the report on the Job Description column (select the column in the list then use the Group button on the toolbar) then select the Hourly Rate column and press the Aggregate button on the toolbar (looks like a sigma) - choose Average from the list of aggregations. This will add in the average rate as a footer at the end of each Job Description group.

Cheers!

MF.
Meep!

Nickbruno