Skip to Content
0
Nov 07, 2012 at 05:27 PM

Boolean Operators for If... Else Condition in Bex Query

734 Views

Hi Gurus,

Do anybody give a clean slate formula (Boolean Operators in Bex) for below condition

Condition

if ZMASINQTY < (ZUBOCQTY1-ZUBOCQTY2)= ZMASINQTY else ZUBOCQTY2

In Query i have defined as

(A<(B-C) )*A+((A>=(B-C))*C

A = ZMASINQTY

B = ZUBOCQTY1

C = ZUBOCQTY2

Condition :

if ZMASINQTY < (ZUBOCQTY2-ZUBOCQTY1)= 0 else ZUBOCQTY1

In Query

(A<(C-B)*0+((A>=(C-B))*B

A = ZMASINQTY

B = ZUBOCQTY1

C = ZUBOCQTY2

is the above defintion is correct in Query?!

Thanks and Regards,

Ramesh D