BR needs fixing!
Summary
I'm trying to eliminate a certain value but change one dimension member for that data POVContent
Hi everyone,
I'm using Martin Neuliep's intercompany elimination rule, but I'm running into an issue I don't know how to fix.
FIX(
@LEVMBRS("Period",0), @RELATIVE("Profit and Loss Statement",0) AND @UDA(Account,ICPAcc), "Parent Currency", Periodic, @RELATIVE("Intercompany Entities",0), @LEVMBRS(Custom2,0), @LEVMBRS(Custom1,0), @LEVMBRS(Movement,0), @RELATIVE({RTP_Entity},0), {RTP_Version}, {RTP_Years}, {RTP_Scenario}
)
"Intercompany Eliminations"(
@Member(@Concatenate(@Name(@MemberAt(@Intersect(@Ancestors(@CurrMbr(Entity)),@Ancestors(@Member(@SubString(@Name(@CurrMbr(Intercompany)),4)))),1)),"_E")) =
@Member(@Concatenate(@Name(@MemberAt(@Intersect(@Ancestors(@CurrMbr(Entity))
Tagged:
1