The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

pling's avatar
pling
New Contributor II
3 years ago
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 ...
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.
pling's avatar
pling
New Contributor II
3 years ago

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

Related Content