You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BR needs fixing!

Received Response
30
Views
7
Comments
edited Mar 21, 2019 1:32PM in Planning 7 comments

Summary

I'm trying to eliminate a certain value but change one dimension member for that data POV

Content

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!