# Thread: Suggestion on finding totals and averages against non additive measures

1. Junior Member
Join Date
Jul 2008
Posts
3

## Suggestion on finding totals and averages against non additive measures

Hello List ,

We have data in somewhat below form:

 project name resource time taken(Calendar) Man hours P1 R1 100 100 P1 R2 100 100 P2 R3 175 175 P2 R4 175 175 P3 R5 150 150

** Date hierarchy is also present

Out of this data i need to generate two kinds of reports:

1. Total Man hours used in each project which is quite straight forward and I can get it by summing "man hours" column for each project.

2. Place where I need help is calculating calendar duration for each project from calendar point of view. Any suggestions here will be really helpful:
We need results like this:
Calendar Duration for Projects:

P1 = 100
P2 = 175
P3 = 150

Regards,
Ashish

2. Senior Member
Join Date
Jan 2013
Posts
796
Can you say a little more about what the "time taken" measure is and how it is different from "man hours"? Is it elapsed vs. actual?

It might help also if you could give an example of desired results that show both man hours and time taken side by side and how they should differ.

Originally Posted by toashishk
Hello List ,

We have data in somewhat below form:

 project name resource time taken(Calendar) Man hours P1 R1 100 100 P1 R2 100 100 P2 R3 175 175 P2 R4 175 175 P3 R5 150 150

** Date hierarchy is also present

Out of this data i need to generate two kinds of reports:

1. Total Man hours used in each project which is quite straight forward and I can get it by summing "man hours" column for each project.

2. Place where I need help is calculating calendar duration for each project from calendar point of view. Any suggestions here will be really helpful:
We need results like this:
Calendar Duration for Projects:

P1 = 100
P2 = 175
P3 = 150

Regards,
Ashish

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•