Forum Discussion

jacobw's avatar
jacobw
New Contributor III
3 years ago

Minority Interest calculation

Hi community, Does anyone have a good member formula for calculating income/equity attributable to minority interest on the P&L and balance sheet? My understanding is in our case we can report this...
Finance
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

That formula should error out, I'm surprised it doesn't. This is how you perform that check:

 

Dim ownType As OwnershipType = api.Entity.OwnershipType()
If ownType.Equals(OwnershipType.NonControllingInterest) Then
    ....

Also, that dValue is a decimal, so dropping it like that in a formula might give you problems in some configurations (different Cultures might use different decimal characters). Use dValue.XFToStringForFormula() instead

 

  • Krishna's avatar
    Krishna
    Valued Contributor
    1 year ago

    JackLacava  - The If statement does not work if the cube is a multuCube & it is working for Single Cube. Do you have any example for MultiCube.