9 Replies Latest reply: Feb 27, 2008 10:09 AM by Rakesh Pattani RSS

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

Fulham FC
Currently Being Moderated

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!

Actions