We have a requirement to filter query output based on key figure.
When a query is executed, the query should only display list of orders for which the amount1 is greater or equal to amount2. out of the below record in infoprovider, only record 2 and 3 should be displayed in output.
Please let us know how this can be achieved in query designer. ThanksOrder No Amount 1 Amount 2 100 5000 6000 101 6000 6000 102 7000 6000