Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

IF THEN ELSE STATEMENT IN BeX Query designer

Hi,

I want to write a query as follows:

IF <Value a> is available THEN <Value a> ELSE <Value b>

I have written it as follows:

(X>0)X+(X<=0)Y

The problem with this equation is, in case X = 0(number Zero) then Y is not getting displayed. But In case X =NULL (or no values) then Y displayed. This is leading to inconsistency in final result. Please help in rectifying the formula incase it is incorrect or is it because of some program bug in BeX?

Regards

Madhav

Former Member
Not what you were looking for? View more on this topic or Ask a question