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

Condition over a Formula in a query

Hi to all.

I have one report in where there is a difference between two dates created as Key Figures (Date 1 - Date 2), but I want see in the report only that rows in where Date 1 > Date 2.

I've created a condition over the Formula saying that Formula Greather than 0, but after when I launch the report I don't see data.

There are cases into infoprovider which must appear in the query.

Do you know what I'm doing wrong?

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2008 at 04:49 PM

    Hello,

    You cannot have conditions on the keyfigure values. You can conditions on characteristics which will display only those characteristics above or below a certain key figure. But you cannot restrict based on keyfigure itself. Hope it helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 02:02 PM

    Finally I've created a new KF inside Data Model being filled with one formula in the update rule.

    After the condition was created over this new KF

    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.