Solved

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 to change it so it does not include zeros, by applying the removezeros function:

sourceActualsBuffer = api.Data.GetDataBuffer(DataApiScriptMethodType.Calculate,"RemoveZeros(S#Actual_Opco:U5#None)",False, destinationBuffer)

When I do this, I get an error see attachmement.

I tried to change the quotes RemoveZeros("S#Actual_Opco:U5#None") but then i get a different error when validating.

Could not find anything in the reference on how to fix this. Anybody can help?

Best answer by Henning

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.

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.

plingAuthor

Thanks Henning! seems to work. Need to further test it!

Yes the RemoveZeros function for the script is wonderful. It would also be nice to apply that command to a DataBuffer object.

Please vote for this enhancement:

https://community.onestreamsoftware.com/idea/PlatformCore/add-removezeros-as-a-databuffer-method/45348

Sign up