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
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
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
Thanks Sunny it worked perfectly.....
Sunny,
Zero suppress does not work now.....any ideas?
Is it possible that Over-Payment is not 0, but a really small number like 0.0000152 or something like this?
Very small number, but should be 0
Not sure I understand? Are you saying that it is a very small number, but it should have been 0?
Very small number and should be made 0
May be use a Round() function or Floor()
Round(Expression, '0.01')
Thanks Sunny it worked