Exclude a row in a table, based on a condition?

[stephenhasson]

Hi,

If I have

-Part Number

- Description

- Onhand-Qty

as columns in a table, how do I prevent rows where the 'Onhand-Qty' = 0 from being shown?

I've tried Aggr function, If statement etc, but can't figure it out.......

I can suppress the '0' and get '-' instead, but I can't get the rows to be excluded.

Thanks.

[sunny_talwar]

Not syre, but have you tried set analysis?

{<[Onhand-Qty] -= {'0'}>}

[stephenhasson]

Thanks for your reply. I've tried all sorts of variations...... Not sure if I even should be trying to use set analysis or condition logic? Can't find any suitable documentation.

Stephen

[sunny_talwar]

Would you be able to share a sample to show what you have and explain what you need to get from it?