Forum Discussion

IM_T's avatar
IM_T
New Contributor
16 days 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
    Valued Contributor
    15 days ago

    Have you already tried row suppression in the cube view?

     

    • IM_T's avatar
      IM_T
      New Contributor
      13 days ago

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