Hyperion Minority Interest Rule Help
Hello, I am trying to revise or add a metadata rule that calculates minority interest (both income statement and balance sheet impact) based on a minority interest percentage assigned in Hyperion. This rule works to where it takes net income of the base entity (which has been identified as a minority interest base entity in the UD2 field of the entity setup in metadata) multiplied by the minority interest percent entered to arrive at the balance in the minority interest income statement and balance sheet account. Upon consolidation, the values in the minority interest accounts are moved to the income statement and balance sheet minority interest accounts. This rule was working fine until we acquired a foreign entity with a minority interst percent. When I set up the minority interest percent on the base entity (which has a different entity currency than the parent), it calculates the minority interest amount correctly in the foreign currency, but when it translates from the entity currency to parent currency, it takes the foreign currency exchange rate entered for the balance sheet and income statement account instead of keeping both at the same translated USD amount. This results in an out of balance in our balance sheet since the translation gives two different USD values. The minority interest should be calculated on the foreign entity but equal the USD equivalent of the minority interest percent of net income. I would like the minority interest calculation to occur after translation of net income from entity to parent currency for this foreign entity. I have tried to create a rule, but am having a difficult time, how do I create a nesting statement within an exisiting rule that states, if the base entity has a different currency than the parent, run translation first, then calculate minority interest on the translated USD value?