Skip to main content
Newcomer
June 9, 2025
Question

RemoveZeros from CubeView

  • June 9, 2025
  • 1 reply
  • 0 views

Hi, is there an easy way to remove rows with zeros from the Cube View when using GetDataCell? Thanks

GetDataCell(S#|!Scenario!|_Allocations:U3#None:U4#None:U5#None:U6#None:U8#PCRunRate - S#PPM_|!Scenario!|_Lite:UD2#PrjNa):Name(Variance)

 

1 reply

T_Kress
OneStream Employee
OneStream Employee
June 10, 2025

Have you already tried row suppression in the cube view?

 

IM_TAuthor
Newcomer
June 12, 2025

Hi, yes, suppression is on, haven't entered the threshold as report can contain both negative and positive amounts.