Straight Table - Only show field names where expression > 0

[kwarren1]

Hello,

Is it possible to only display the DepartmentName within a Straight Table if the expression column is greater than 0?

[Anonymous]

[MarcoWedel]

Hi,

actually that's default behaviour. Try checking "Suppress Zero-Values" on the Presentation tab of the straight table properties.

Please post a sample qvw to demonstrate if it's not working.

hope this helps

regards

Marco

[swuehl · Accepted solution]

Are you maybe talking about a list box with an expression?

Maybe use a field expression (select <expression> from field drop down on general tab) like

=Aggr( If(Sum({<DepartmentName>} Sales) >0, Only({<DepartmentName>} DepartmentName)), DepartmentName)

Replace Sum(Sales) with your expression.

[kwarren1]

Wow. Way to read between the lines on that one! Sorry about misleading with the Straight Table, I did mean List Box. The Aggr formula worked brilliantly!

Thank You!