Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is it possible to only display the DepartmentName within a Straight Table if the expression column is greater than 0?
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.
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
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.
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!