FCCS - return intercompany ownership method in Dynamic Calc

Summary:

Our clients require AR and AP reporting segmented by intercompany consolidation method—such as IC-to-Subsidiary, Equity, and other classifications.

I'm currently developing a dynamic calc that utilizes the Custom2 dimension to retrieve the consolidation method associated with each Intercompany. Despite testing several scripts recommended by the community, I haven’t been able to get it working as expected.

Any suggestion would be greatly appreciated.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

"FCCS_Consol Method" -> "S_GI23" -> "FCCS_Entity Input" -> "No Currency" -> "FCCS_Periodic" -> "FCCS_No Movement" -> "No Custom1"-> "No Custom2"-> "No Custom3" -> "FCCS_No Intercompany" -> @MEMBERAT (@EQUAL (@SUBSTRING (@NAME (@CURRMBR ("Intercompany")), 4), "Entity"),-1);