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

IM_T's avatar
IM_T
New Contributor
1 year ago

RemoveZeros from CubeView

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)

 

Cube View
Reports

2 Replies

  • T_Kress's avatar
    T_Kress
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    Have you already tried row suppression in the cube view?

     

    • IM_T's avatar
      IM_T
      New Contributor
      1 year ago

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