Forum Discussion
BenEppel
3 days agoNew Contributor III
Dim startingBuffer2m1 As String = "Cb#XXXXXXX:T#" & TimePrior & ":A#" _
& Denominator & ":S#Actual:E#XXXXXXXX:F#EndBal_Input:V#Periodic"
Dim startingBuffer2m2 As String = "Cb#XXXXXXX:T#" & TimePrior2 & ":A#" _
& Denominator & ":S#Actual:E#XXXXXXXX:F#EndBal_Input:V#Periodic:"
Dim startingBuffer2m3 As String = "Cb#XXXXXX:T#" & TimePrior3 & ":A#" _
& Denominator & ":S#Actual:E#XXXXXX:F#EndBal_Input:V#Periodic:"
Dim Denominator1 As DataBuffer = api.Data.GetDataBufferUsingFormula(
"RemoveZeros(FilterMembers(" & startingBuffer2m1 & ", " & filter1 & ", " & filter2 _
& "))",, True)
Dim Denominator2 As DataBuffer = api.Data.GetDataBufferUsingFormula(
"RemoveZeros(FilterMembers(" & startingBuffer2m2 & ", " & filter1 & ", " & filter2 _
& "))",, True)
Dim Denominator3 As DataBuffer = api.Data.GetDataBufferUsingFormula(
"RemoveZeros(FilterMembers(" & startingBuffer2m3 & ", " & filter1 & ", " & filter2 _
& "))",, True)
api.Data.FormulaVariables.SetDataBufferVariable("Denominator1", Denominator1, False)
api.Data.FormulaVariables.SetDataBufferVariable("Denominator2", Denominator2, False)
api.Data.FormulaVariables.SetDataBufferVariable("Denominator3", Denominator3, False)
Dim db_DenominatorAvg As New DataBuffer
db_DenominatorAvg = api.Data.GetDataBufferUsingFormula(
"($Denominator1+$Denominator2+$Denominator3)/3")
Break out the formula variables by account and then add them together before dividing like db_DenominatorAvg above.
Related Content
- 4 years ago
- 10 months ago
- 8 months ago