Skip to Content
0

2 conditions in BEx query

Apr 27 at 06:16 AM

45

avatar image

Hi,

I have two conditions on 2 key figures.

1.Stock value not equals to "0" - To eliminate records from report where stock value is 0.

2.Unit price Not equals to "0" - To eliminate records from report where unit price is 0.

when i create these two conditions, the second one working and 1 condition is not getting applied to query. I wanted to work these two condition with "AND" which means both condition should work.

Regards,

Anand

condition.jpg (94.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Apr 27 at 06:52 AM
1

Hi,

Have you tried creating 2 really different conditions, instead of 1 condition with 2 parameters?

Grtz

Koen

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thank you Koen.

That worked now. Created 2 conditions now. Initially created 2 parameters in one condition.

Thanks & Regards,

Anand

1

Hi Anand,

the solution provided by Koen is also described in the online help:

Linking to Conditions: Bottom 2 Revenue and Invoiced Quantity 100,000,000

You can find also more samples on working with conditions in the SAP Help:

Using conditions

Cheers,

Nora

0