If then else statement in bex

[Former Member]

Does anyone know how to create an If Then Else statement in BEX?

[Former Member · Accepted solution]

Hi syed,

I think this might help you...

(( 'Cumulative Value GC' > 0 ) * 'Dummy Key Figure') + (( 'Cumulative Value GC' <= 0 ) * 15)

If 'Cumulative Value GC' > 0.

rslt = 'Dummy Key Figure'.

else.

rslt = 15.

endif.

check out and reward me if its helpful.

regards,

ani

[Former Member]

Hi,

Check the help.

http://help.sap.com/saphelp_nw04/helpdata/en/23/17f13a2f160f28e10000000a114084/content.htm

Regards.

[Former Member]

Hi Syed,

Please go to BEX query designer.

Select or create new CKF

Go to operator as data function (just below percentage function).

Delta of something non zero populates 1 else Delta populates 0.

You have only this much possibility in BEX while creating if then else function.

If the above info found useful, please reward me with points.

Regards,

Subha

[Former Member]

Hi Syed,

You can create a IF-THEN-ELSE statement using the Boolean Operators given in BEx

(Eg)

IF<Logic Expression> THEN <Expression1> ELSE <Expression2>

this expression can be made using a formula in the form

<Logic Expression> * <Expression1> + NOT <Logic Expression> * <Expression2>

Regards,

vasanth.vf