Account formula help
SOURCE: ONESTREAM CHAMPIONS
Hi all,
I have a very random request for anyone who may have the time to review and hopefully point me in the right direction.
The formula calc is an on account and is unbalanced - I’m specifying more dimensions on the right side of the equation than the left (T#, E# and C#) which is giving me a data explosion error. I have examples of formulas currently in use where T# is on one side but not the other and the formula works fine so I’m guessing it’s an issue with E# and C# but I can’t seem to figure out how to make it work
Here’s the formula:
If Not api.Entity.HasChildren And api.Cons.IsLocalCurrencyForEntity Then
Dim vEnt As String = api.Pov.Entity.Name
Select Case vEnt
Case “ENT_1095”
api.Data.Calculate(“A#520_211010:V#Periodic:O#Import:F#EndBal:U1#NABalanceSheet:U3#Source:U4#None:U5#None:U6#None:U7#None:U8#None =
A#ACC_SAP_134450:T#POVPriorYearM12:E#ENT_2000:C#CAD:V#Periodic:O#Import:F#EndBal:U1#NABalanceSheet:U3#Source:U4#None:U5#None:U6#None:U7#None:U8#None
* A#ClosingRate:E#ENT_2000:C#CAD:V#Periodic:O#Top:F#EndBal:U1#NABalanceSheet:U3#Source:U4#None:U5#None:U6#None:U7#None:U8#None”,“I#Top.base”,“U2#Paladin.base”,True)
End Select
End If
Any thoughts on how to resolve? Any info or feedback would be much appreciated!!
Some additional background:
-There are members in the values above (A#ClosingRate and A#ACC_SAP_134450 with the respective dimensions specified)
-The calc works fine if specify one I# and one U2# member though I must update the formula as follows:
Dim v134450InFormula As Decimal = api.Data.GetDataCell(“A#ACC_SAP_134450:T#POVPriorYearM12:E#ENT_2000:C#CAD:V#Periodic:O#Import:F#EndBal:U1#NABalanceSheet:U3#Source:U4#None:U5#None:U6#None:U7#None:U8#None”).CellAmount
Dim vClosingInFormula As Decimal = api.Data.GetDataCell(“A#ClosingRate:E#ENT_2000:C#CAD:V#Periodic:O#Top:F#EndBal:U1#NABalanceSheet:U3#Source:U4#None:U5#None:U6#None:U7#None:U8#None”).CellAmount
api.Data.Calculate(“A#520_211010:V#Periodic:O#Import:F#EndBal:U1#NABalanceSheet:U3#Source:U4#None:U5#None:U6#None:U7#None:U8#None = “& v134450InFormula &”*”&vClosingInFormula)
