If ever in SAP Bex reporting you are faced with the challenge of populating a column or a cell based on values in two other columns or cell values use the following in a formula.
Example – Column1 = 50, Coulmn2 = 110, Column3 = [If value in column2 > 100 then use column2 else use column1]
The above requirement can be written in a bex formula as
(( column2 > 100) * column2) + ((Column2 < 100) * Column1)
one easy way to remember it as a “if then else” statement is to substitute the first condition as a default “if”. In the above example
column2 > 100 (If column2 > 100)
replace the * with THEN
replace + with ELSE