IF...ELSE.. STATEMENT in BEx Query Designer
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