Formula change in Opening and Closing line items.

RISINGSTAR
Occasional Contributor

Formula change in Opening and Closing line items.

Hi Team,

 

I needed small help to optimize the formula from Half-Year to Full-year.

 

Current working System:   If Jan 2021 (Budget) H1 Opening HC we were referring to Closing HC of Dec 2020(Actual) and IF July 2021(H2) we were referring to Jun 2021(Actual)

 

Proposed System: If Jan 2021 (Budget) H1 Opening HC we were referring to Closing HC of Dec 2020(Actual) and IF July 2021(H2) we were referring to Jun 2021 Closing HC (Budget)

 

attaching the Screenshots of the Formula and model.

 

IF MONTH(START()) <= MONTH('Basis Month -W') AND ITEM(Customized Versions) = Customized Versions.Forecast

THEN

Derive Actual Fully Loaded Cost.FTE HC

ELSE

IF

ITEM(Customized Versions) = Customized Versions.'Budget 1' AND 'Department L5'.'Exception of Edit(for CE-POPS)'

THEN

CE Summary Report Module.'FTE(Agent/Suppot-Existing)'[SELECT: 'MAPA/PAPL'.MAPA, LOOKUP: 'City L4'.'Parent (Default City)']

ELSE

IF (START() = 'H1/H2 Control'.Yearvalue Budget Start Date[SELECT: 'H1/H2'.'H1'] OR START() = 'H1/H2 Control'.Yearvalue Budget Start Date[SELECT: 'H1/H2'.'H2']) AND ITEM(Customized Versions) = Customized Versions.'Budget 1' AND NOT 'Department L5'.'Exception of Edit(for CE-POPS)'

THEN

PREVIOUS(Closing HC[SELECT: Customized Versions.Forecast])

ELSE PREVIOUS(Closing HC)

 

 

 

Thanks,

Uday