Forum Stats

  • 3,733,521 Users
  • 2,246,780 Discussions
  • 7,856,752 Comments

Discussions

Member formula Syntax

User_AP0RO
User_AP0RO Member Posts: 5 Green Ribbon
edited April 2020 in Financial Consolidation

Hi Experts,

I try to copy data from one hierarchy to anther hierarchy through MEMBER FORMULA. I have used @CONCATENATE function in the formula and It is picking members correctly from source members but @CONCATENATE is not working for target members. Please see below formula for more clarification.

"Periodic"->@MEMBER(@CONCATENATE(@NAME(@CURRMBR("Account")),"_FCTR"))->"Entity Input" = "Periodic"->@MEMBER(@CONCATENATE(@NAME(@CURRMBR ("Account")),"_FC"))->"Entity Input"->"No Locations";

pastedImage_2.png

I have entered 600 at Invest1_FC which is my source and expected is 600 copied to Invest1_FCTR. But here it is copying data to Invest1 member.

Kindly provide your suggestions how I can solve this one.

Regards,

SK

Answers

  • Anand Thota
    Anand Thota Member Posts: 28 Red Ribbon

    Hi Sk,

    IN order to copy data from Invest1_FC to Invest1_FCTR member you can use very simple formula like below.

    "Invest1_FC"+"Invest1"-"Invest1";

    or "Invest1_FC"

    Thanks,

    Anand Thota

Sign In or Register to comment.