Show when <> 0

[tmumaw]

I have this pivot table where I only want to show the lines which have a value in one column (over-payments).  Is there a way to do this?

Thanks

[sunny_talwar · Accepted solution]

Update all your expressions to have this condition in them

If([Over-Payment] <> 0, Expression1)

If([Over-Payment] <> 0, Expression2)

If([Over-Payment] <> 0, Expression3)

...

...

and so on

You can leave the Over-Payment expression as is, but update all other expressions

[tmumaw]

Thanks Sunny it worked perfectly.....

[tmumaw]

Sunny,

Zero suppress does not work now.....any ideas?

[sunny_talwar]

Is it possible that Over-Payment is not 0, but a really small number like 0.0000152 or something like this?

[tmumaw]

Very small number, but should be 0

[sunny_talwar]

Not sure I understand? Are you saying that it is a very small number, but it should have been 0?

[tmumaw]

Very small number and should be made 0

[sunny_talwar]

May be use a Round() function or Floor()

Round(Expression, '0.01')

[tmumaw]

Thanks Sunny it worked