Forum Discussion

Larry_Manekin's avatar
Larry_Manekin
New Contributor II
7 months ago

Using Percent Ownership in a member formula

Hi, This formula is working, but it's returning 100% for each Entity. Is there something I'm missing regarding Entity? Will this work in a member formula or only in a business rule? Dim entity As...
Finance
  • Big_Rick_CPM's avatar
    Big_Rick_CPM
    7 months ago

    Ownership percentages are relationship (parent/child) specific. Your formula currently only runs on base and local, which is not relationship specific. You will need to pass a specific parent in for the entity you want the ownership value for. The api you are using to get ownership rate has a second argument you can pass through for parent. In my experience, those calculations run on different consolidation members (not Local but something like OwnerPreAdj, Share, OwnerPostAdj, etc).

Big_Rick_CPM's avatar
Big_Rick_CPM
Contributor
7 months ago

Ownership percentages are relationship (parent/child) specific. Your formula currently only runs on base and local, which is not relationship specific. You will need to pass a specific parent in for the entity you want the ownership value for. The api you are using to get ownership rate has a second argument you can pass through for parent. In my experience, those calculations run on different consolidation members (not Local but something like OwnerPreAdj, Share, OwnerPostAdj, etc).