Forum Discussion

Yaseen's avatar
Yaseen
New Contributor III
2 years ago

Error using Where clause with 'or' condition inside GetDataBufferUsingFormula

Hello -   is there a way to make the below work inside GetDataBufferUsingFormula . Getting Error processing script 'V#Periodic:F#EndBal_Input:A#:U1#USF02'. Dim SrcDataBuffer As DataBuffer = api.D...
Finance
  • EricOsmanski's avatar
    EricOsmanski
    2 years ago

    Try this removing the square brackets from around the member name, so you don't have 2 sets.

     

    Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic:F#EndBal_Input:S#Actual:T#" & sLastActMth & ":U1#" & mCostCenter.Member.name & ",[A#PNL.Base.Where((Name StartsWith '4') or (Name StartsWith '5') or (Name StartsWith '7') or (Name StartsWith 'X'))], [U3#TopUD3.Base],[U2#TopUD2.Base])").

EricOsmanski's avatar
EricOsmanski
Valued Contributor

Try this removing the square brackets from around the member name, so you don't have 2 sets.

 

Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic:F#EndBal_Input:S#Actual:T#" & sLastActMth & ":U1#" & mCostCenter.Member.name & ",[A#PNL.Base.Where((Name StartsWith '4') or (Name StartsWith '5') or (Name StartsWith '7') or (Name StartsWith 'X'))], [U3#TopUD3.Base],[U2#TopUD2.Base])").

Yaseen's avatar
Yaseen
New Contributor III
2 years ago

Thanks Eric, removing the square brackets worked.