Skip to Content
author's profile photo Former Member
Former Member

Suppress row when one column contains zero

I have a query that displays several key figures as columns, when one of these key figures = 0, the row should not be displayed. I can't use zero suppression because the other columns have values of not zero.

Anybody have any idea how I can do this?

Thanks

Brigitte

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 03:41 AM

    Is it something like Cells having zeroes should be suppressed ?

    Not the complete row itself .....

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 03:54 AM

    The entire row has to be supressed if zero appears in a particular column of that row.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 04:45 AM

    Thanks anyway. I worked it out myself. I needed to create a Condition.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 10:40 PM

    I'm on 3.5 so it might be different for you, but this is step-by-step what I did...

    Choose Exception toolbar button, select New Exception, enter a Description and click in Active (or you can leave it blank and activate it from the report). Select the Key Figure you want to use. In Exception Values tab From and To columns, put a range of values and choose an Alert value then press Transfer button. In Validity Area of Exception, select whether you want the highlighting to appear on all lines or only totals. Then choose the characteristic(s) you want the condition to be shown for. If the report user doesn't have that characteristic(s) in their drill down, the condition will not show. Then choose the Operator (play with these to see which one you want). Depending on the Operator, you may then have to specify a Value. Eg if your characteristic is Customer, you may want the condition to apply to all customers or only ones of a specific value. Again, press on Transfer. Then OK.

    I even got fancy and created a variable in by Exception Values From column so that my customer can select what percentage from value they want to see highlighted. I also found I had to fill To column with all 9's to get a high value - because in 3.5 I can't select "greater than" which I know can be done in later versions.

    Anyway, have a play with all the options. If I could work it out I'm sure anybody can.

    Regards

    Brigitte

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.