on 2023 Apr 28 10:51 AM
Hi,
I am unable to create a member formula in Accounts where I need a revenue account of Geography A being divided by the cost account of a Geo B. Here in, Geo B is related to Geo A using a property "Country"
I have tried the following methods but they have been unsuccessful:
1. ([OC500A])/([STAT_UOAA],[GEOGRAPHY].CURRENTMEMBER.PROPERTIES("COUNTRY"))
2. ([REV01])/([COST01],[GEOGRAPHY].CURRENTMEMBER.PROPERTIES("/CPMB/FDYUD"))
- in reference to the tech id for "Country"
3. ([REV01])/([COST01],[ENTITY].CURRENTMEMBER.PROPERTIES("/CPMB/FDYUD"))
4. ([REV01])/([COST01],[ENTITY].[H1])
- since data is stored in only one of the base members for cost
Please help
User | Count |
---|---|
9 | |
4 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.