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 ...
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.
