Archived discussions are read-only. Learn more about SAP Q&A

IF...ELSE.. STATEMENT in BEx Query Designer

Hi,

Why there is no IF, ELSE function in BEx Query Designer?

Assuming I need to write the following logic, how can it be accomplished?

IF (A=0 OR B=0)

THEN 0

ELSE IF ( B/A <0)

THEN ' *'

ELSE

B/A * 100

i.e.

if A or B is equal to 0, then display the value of 0

else if B is negative (as A is either 0 or positive), then display the following text: ' *'

otherwise, display the value of B/A * 100

Thanks!

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question