Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Is it possible to hide rows which has 0's in straight table without using INCLUDING ZERO VALUES ?
Eg:
Desc, Amount
A,0
B,0
C(A+B), 0
D,1
E,2
Requirement is A and B row should be hidden if they are zeros and C (A+B) should be shown on the table if it is zero.
Hi, maybe setting null() in the expression, but you will need extra checks, like:
If(Match(Desc,'A','B')
,If(Sum(Amount)=0
,Null()
,Sum(Amount)
,Sum(Amount)
)