Question

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)

Have you already tried row suppression in the cube view?

IM_TAuthor

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

Sign up