Data Buffer FilterMembers() with Empty Cells
Does the api.Data.GetDataBufferUsingFormula("FilterMembers(...)") only get cells that have values?
Is there a way to create a data buffer with empty cells?
Use case: We need to to cycle th...
Forum Discussion
You can use this
Dim Dstpath as string will have your intersections for destination without data units.
Dim SrcBuffer as string will use this info to create a data buffer "V#YTD:F#End_Bal:O#Import:U2#000:U3#0000:U4#0:U5#None:U6#None:U7#None:U8#None"
api.Data.Calculate(DstPath+" = Eval($SrcBuffer)",,,,,,,,,,,,,AddressOf OnEvalDataBuffer,,True)
Create a function with this signature. Inside this function you can access the databuffer using eventargs.databuffer1
this works in the exact same way as a DBCL rest you can manipulate as per your requirement.
Private Sub OnEvalDataBuffer(ByVal api As FinanceRulesApi, ByVal evalName As String, ByVal eventArgs As EvalDataBufferEventArgs)
eventArgs.DataBuffer1
End sub
Right.... Using Eval(), AddressOf OnEvalDataBuffer generates an unknown error. we're trying to understand why.
