Cal: Report Date
[Resource Date] <= [Param: Report Date]
Physical % Complete
{ FIXED [Work Package]
:
SUM(
IF [Cost Class] = ‘Earned’ AND [Cal: Report Date] = TRUE THEN [Item Cost] END
)
}
/
{ FIXED [Work Package]
:
SUM(
IF [Cost Class] = ‘Budget’ AND [Cal: Report Date] = TRUE THEN [Item Cost] END
)
}
SV by WP
{ FIXED [Work Package]
:
SUM(
IF [Cost Class] = ‘Earned’ AND [Cal: Report Date] = TRUE THEN [Item Cost] END
)
}
–
{ FIXED [Work Package]
:
SUM(
IF [Cost Class] = ‘Budget’ AND [Cal: Report Date] = TRUE THEN [Item Cost] END
)
}
CV by WP
{ FIXED [Work Package]
:
SUM(
IF [Cost Class] = ‘Actual’ AND [Cal: Report Date] = TRUE THEN [Item Cost] END
)
}
–
{ FIXED [Work Package]
:
SUM(
IF [Cost Class] = ‘Budget’ AND [Cal: Report Date] = TRUE THEN [Item Cost] END
)
}