Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Numeric ID used in Member Formula not working properly

Hello experts,

I'm working with member formulas and I'm facing the following issue. I've a calculated account member (Account ID: 520000_001) and I need that member to has the same value of account 110505. I'm writing in 520000_001 FORMULAH2 property the ID "110505" (without quotes), and it's putting me in the reports in the account 520000_001 the value 110.505, and not the value of the 110505 account.

I've tried with the following syntax in the FORMULAH2 property:

110505 (Put the numeric value) - I know this syntax work because I'm using it with other alphanumeric ID's (ie. BG52500)

'110505 (Excel syntax for specifying an explicit text - Put the numeric value)

[110505] (Returns nothing)

[Cuenta].[110505] (Returns nothing)

[Cuenta].[H1].[110505] (Returns nothing)


The 110505 account has value, and i'm querying in the correct data region. We've 2 hierarchies, the account belongs to both ( I mean, it's present in a node in PARENTH1 and another node in PARENTH2).


Any clue?


Thanks in advance!

Former Member
Former Member replied

Hi Andres,

I have tried to create a little test in my BPC.

I have set up accounts 12345, 23456, 34567, 45678 and 56789. 12345 is a base account and I set it up to be added to 23456 in H1 and 34567 in H2. 45678 is also a base account and I set it to add into 56789 in H2.

For 45678 I then set FORMULAH2 as [12345] and I got the same result you got. I then changed account 12345 so it was only used in H1 and suddenly the formula worked.

So I don't think it is to do with the ID being numeric but more with your account 110505 being used in both hierarchies.

My first thought would be to use a script to copy the amount on account 12345 to some other account which would only be used in H2 and in the formula you are trying to create. Instead of a script you could also use the account based calculation business rule for this or use a script instead of the formula.

BR,

Arnold

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question