SBIE Average's translation in TRCS

Jun 17, 2025 11:24AM

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).

SBIE Average's translation in TRCS

Howdy, Stranger!