Skip to Content
0
May 13, 2014 at 06:00 PM

Filter query output based on key figure

46 Views

Hi Experts,

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. Thanks

Order No Amount 1 Amount 2 100 5000 6000 101 6000 6000 102 7000 6000