Okay - If i'm understanding you correctly, your member formula in the screen shot above is executing and you want the results of that to then be eliminated later at the common parent?
If that's the case, i suspect the issue is that you're writing the result to O#Elimination. I don't believe this will be picked up by the standard consolidation for eliminations.
regards,
Thanks again, Karl.
I've tried changing the Origin setting for my calculation to "Import", "Forms" and "AdjInput". If it is set to anything other then O#Elimination, the balance is not calculating at all.
Imports System
Imports System.Data
Imports System.Data.Common
Imports System.IO
Imports System.Collections.Generic
Imports System.Globalization
Imports System.Linq
Imports Microsoft.VisualBasic
Imports OneStream.Shared.Common
Imports OneStream.Shared.Wcf
Imports OneStream.Shared.Engine
Imports OneStream.Shared.Database
Imports OneStream.Stage.Engine
Imports OneStream.Stage.Database
Imports OneStream.Finance.Engine
Imports OneStream.Finance.Database
Namespace OneStream.Formula
Public Class MainClass
Public Sub Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api as FinanceRulesApi, ByVal args as FinanceRulesArgs)
Try
'XFFormula
'July 18th, 2024, Yan Savinsky. First Version
If (api.Cons.IsRelationshipLevel And api.Entity.OwnershipType().ToString = "Custom1")
'If ((api.Cons.IsRelationshipLevel) And (api.pov.Cons.Name = "Elimination") And (api.Entity.OwnershipType().ToString = "Custom1"))
Dim entityID As Integer = api.POV.Entity.Memberpk.Memberid
Dim parentID As Integer = api.POV.Parent.Memberpk.Memberid
Dim pOwn As Decimal = api.Entity.PercentOwnership(entityID, parentID)
' Dim entityName As String = api.Pov.Entity.Name.ToString
Dim entityName As String = api.Entity.Text(8)
' api.Data.ClearCalculatedData("C#Elimination:A#399600_IC:F#EndBalCalc:O#Elimination",True,True,True)
api.Data.Calculate("C#Elimination:A#399600_IC:F#EndBalCalc:I#" & entityName & ":O#Import = C#Local:A#EquityToCommon:F#EndBalCalc:I#None:O#Top * " & (1 - pOwn/100))
End If