IF THEN ELSE STATEMENT IN BeX Query designer
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:
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?