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

Condition on cells

Hi,

There is cell reference in the query. The formula in the cell reference is if the number of days is greater than 30, it is 1 else it is 0. Now, I need to get only the records with the formula 1.

When the condition is added, the condition is not effective and the report brings out all the records both with 0 and 1.

How to solve the condition in cells?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2010 at 11:12 AM

    Cell editor is used for display of data for that particular cell based on some condition not for filtering the records.

    you want to display the info as 1 or 0 based on some condition, hence its doing the same, but if you want only the records with value 1 then thats filtering.

    use the section Filter with that characterstic >30 or if its a key figure cuse Condition with KF>30 and you will see all the recoreds with value 1 in the report.

    hope this help.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 11, 2010 at 11:22 PM

    Hello,

    Please understand the following:

    "Conditions are active: If you apply conditions to a query, you

    are not changing any numbers. Instead, you are just hiding the

    numbers that are not relevant for you. This means that

    conditions do not effect Results Rows (same as without the

    condition). Zero Suppression works the same way."

    Thanks,

    Diego Seben.

    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.