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



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 '       *'


    B/A * 100



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