Forum Discussion

pling's avatar
pling
New Contributor II
3 years ago

Removezeros in getdatabuffer

Hi, We have a seeding rule that is copying zeros: sourceActualsBuffer = api.Data.GetDataBuffer(DataApiScriptMethodType.Calculate,S#Actual_Opco:U5#None,False, destinationBuffer)   I am trying ...
Finance
  • Henning's avatar
    Henning
    3 years ago

    Hi, you can use GetDataBufferUsingFormula, e.g.

    api.Data.GetDataBufferUsingFormula("RemoveZeros(FilterMembers(S#ACT:O#Top,F#Closing.Base))",,False)
     
    You can also use your data buffer, loop through the cells and remove the zeros and no data cells like that.
Henning's avatar
Henning
Valued Contributor II
3 years ago

Hi, you can use GetDataBufferUsingFormula, e.g.

api.Data.GetDataBufferUsingFormula("RemoveZeros(FilterMembers(S#ACT:O#Top,F#Closing.Base))",,False)
 
You can also use your data buffer, loop through the cells and remove the zeros and no data cells like that.
Related Content