BW Formula for else if

[former_member327592]

Hi,

I need help.

I am using the below formula in the transformation routine but due to some reasons this is not working in BW4HANA so i would like to try using Formula.

IF ( A = ''

OR A = '00000000' ).

RESULT = ''.

ELSEIF ( B = ''

OR B = '00000000' ).

RESULT =C.

ELSE.

RESULT = B.

ENDIF.

Can you please help how to write this using Formula in Transformation?

Thanks

Mano

[roland_szajko]

The TRFN editor only allows the IF function. There is no ELSEIF function. What do you exactly mean with "this is not working in BW4HANA"? Is it throwing an error? Is it producing a wrong result?

What is the expected result?

Btw. the formula provided by "abhishek.hazra" seems to deliver exactly what you need.