Derive the Year from another field
Hi, What I want to do: I want the "Year" fields to derive which year it is based on the Business Case Start Date. but I don't want the year to be static. The fields I feel are important: [YE...
Forum Discussion
This is my formula: - so how could each "year" field be a specific year based on the business case start date (different for each business case)
If(
[Request] = "Add New Resource" and [New Employee Type] = "FTE",
[PRM Level - New FTE Monthly Estimate] * [First Year Duration],
If(
[Request] = "Add New Resource" and [New Employee Type] = "Contractor",
[Contractor Monthly Estimate] * [First Year Duration],
If(
[Request] = "Include Existing Contractor - No Conversion",
[Contractor Monthly Estimate] * [First Year Duration],
If(
[Request] = "Include Existing FTE - Continue or Shift Project",
[FTE PID - Level Estimate - Monthly Estimate] * [First Year Duration],
If(
[Request] = "Add New Contractor + Add New FTE for Conversion",
[Contractor Monthly Estimate] * [First Year Duration],
If(
[Request] = "Include Existing Contractor + Add NEW FTE for Conversion",
[Contractor Monthly Estimate] * [First Year Duration],
If(
[Request] = "New FTE (Related to Conversion)",
[PRM Level - New FTE Monthly Estimate] * [First Year Duration])
))))))