FCCS Add Backs Calculation in FCCS1_0
Hi,
What's the best pratice for automating Net income Addbacks using FCCS_10 and a specific cashflow adjustment data souce as target ?
example:
FIX ("Entity Currency")
/*Step 1: run BOTTOMUP on the single FIX-ed target block using sparse as anchor*/
FIX ("FCCS_Periodic", @RELATIVE("TOT_Depr", 0), @RELATIVE("Total Custom 1", 0), @RELATIVE("Total Custom 2", 0), "CASHFLOW ADJ", @LIST("Depreciation AddBack","FCCS_Mvmts_NetIncome")
"FCCS_Entity Input" (
@CALCMODE(BOTTOMUP);
IF (NOT @ISMBR("FY23"))
IF (@ISLEV("Entity", 0))
"Depreciation AddBack" = #Missing;
"FCCS_Mvmts_NetIncome" = #Missing;
ENDIF
ENDIF
)
ENDFIX
SET HYBRIDBSOINCALCSCRIPT FULL;
SET IGNORECONSTANTS TRUE;
/*Step 2: Sucessive Addition -- Calculate add back/reclass on CASHFLOW*/
FIX ("FCCS_Periodic", @RELATIVE("TOT_Depr", 0), @RELATIVE("Total Custom 1", 0), @RELATIVE("Total Custom 2", 0), "CASHFLOW ADJ", @LIST("Depreciation AddBack","FCCS_Mvmts_NetIncome")
0