Skip to main content
pling
Newcomer
Nov 22, 2022 4:42 PM UTC
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?

 

HenningAnswer
Employee - Advisor
Nov 23, 2022 7:55 AM UTC

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.
View in thread

3 replies

Employee - Advisor
HenningEmployee - AdvisorAnswer
Employee - Advisor
Nov 23, 2022 7:55 AM UTC

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
    Newcomer
    Nov 23, 2022 3:46 PM UTC

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

      OneStream Employee
      chris_rothermelOneStream Employee
      OneStream Employee
      Sep 12, 2025 10:10 PM UTC

      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.onestream.com/ideas/5897

       

       

      Terms & ConditionsAccessibility statement