SBIE Average's translation in TRCS
Summary:
Wanted to understand if the translation of the "SBIE average" formula is as intended
Content (please ensure you mask any confidential information):
We have the following formula created in TRCS,
SBIE Average:
if(@ismbr("[TRCS_CYAdjDT].[TRCS_CYAdj]","[TRCS_CYSysDT].[TRCS_CYSys]")and @ismbr(@IDescendants("FCCS_Total Geography"),@IDescendants("TRCS_TotalPillarTwo")))
(("SBIE Adjustments-Eligible Tangible Assets"->"P12"->@MEMBER(@PREVSIBLING(@Currmbr("Years"))) + "SBIE Adjustments-Eligible Tangible Assets")/2);
endif
Current Calculation of SBIE Average is as follows:
the calculation is currently done in sequential steps by default (a) translation using respective FX rates (Scenario,Year,Period) and then (b) taking the average of the translated (Opening + closing).