Filter query output based on key figure

[former_member344089]

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

[anshu_lilhori]

Firstly create a new formula and write if else condition like this:

(Amount 1>=Amount 2)*1+(Amount 1<Amount 2)*0

Now create a global condition by choosing the keyfigure as above formula --Operator Equal to value = 1.

This will display orders which have amount1 greater than amount2.

Note:Make use of Boolean operators at BEx level to write if else conditions.

Regards,

AL