cancel
Showing results for 
Search instead for 
Did you mean: 

Member Formula for Dividing two accounts but with different Geographies

0 Kudos
192

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

Accepted Solutions (0)

Answers (0)