Numeric ID used in Member Formula not working properly
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)
 (Returns nothing)
[Cuenta]. (Returns nothing)
[Cuenta].[H1]. (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).
Thanks in advance!
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  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.