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)
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
Equal to is where you assign value (e.g. A =8 . Here A is assigned a value 8)
Is Equal to is a logical operation where you check whether a value is equal to or not (e.g. A ==8 . Here it checks whether A is equal to 8 or not. If the condition is true it returns 1 or returns 0).
As you said there is no way to populate * in the else part using a formula key Figure