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

suppressing data

Hi All,

I have a report and data like this

Brand : a


time sales

6 455

7 434

8 767

Brand : a


time sales

6 0

7 0

8 0

Brand : b


time sales

6 45

7 43

8 76

Like sales I have many numeric figues. I want to suppress categories data if all measure values are 0 only.If any one is non 0 I have to show that category values with all times.

As per attachment I want to hide these 2 categories

Untitled.png (193.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 17, 2014 at 11:07 AM

    Hi Divya,

    I hope you have a group on the 'Category' field.

    Try this please:

    1) Create a formula called (@zeroes) with this code:

    If {numeric field1} = 0 AND {numeric field2} = 0 AND {numeric field3} = 0 AND {numeric field4} = 0 then 0 else 1

    2) Go to the Group Selection Formula (Report > Selection Formulas > Group) and use this code:

    Sum({@Zeroes}, {Category}) > 0


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 17, 2014 at 11:54 AM

    Hi Divya,

    You can even directly filter these records through record selection by giving following formula :

    {firld1}+{firld2}+{firld3}+{firld4} <> 0

    This will sum up your fields and check if it is zero or not. If zero it will not display else will display that record.


    Add a comment
    10|10000 characters needed characters exceeded

    • If you do this filter at the query level, it will take out rows where all numeric fields on it are zero.

      If you're trying to do this at the query level, then you would also need to group at the query level and get rid of 'groups' where the summary of all numeric fields in a group is zero.


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.