CA Tuesday Tip: Total actuals/ETC differences between project & team

Discussion created by Shawn_Moore Employee on Dec 21, 2010
Latest reply on Oct 14, 2013 by Connie_Fu
CA Clarity Tuesday Tip by Shawn Moore, Sr. Principal Support Engineer for 12/21/2010

TIP: Total Actuals and ETC from the project list page can differ from the Total Actuals and ETC Total on the Team (staff) page. This difference can be due to fact that the project list page is driven off the total ETC and total Actuals for labor resources, but the staff page sums up the values of all team members regardless of resource type.

Note: The above scenario assumes that the user has added an aggregation to sum up the actuals and estimates on the team page.

Additional Information:

The investment allocation job aggregates actuals and estimates for labor resources to populate the LABOR_ACT_CURVE and LABOR_ETC_CURVE and their corresponding sums, which are used for actuals and estimate totals (the LABOR_ACTSUM and LABOR_ETCSUM fields)on the project list.

The Team (staff) page, calculates the sum of each team record from the PRASSIGNMENT table (PRACTSUM and PRESTSUM) fields. This page may contain both labor and non-labor resources.