Question:
Hi All,
Is it possible to use 'if else' loop in BW reports . I need a formula that says if A<>blank only then display B in Bex reporting.
Thanks
GMS
Answer:
Use the Boolean functions in BEx.
Here is an example:
(( 'Cumulative Value GC' > 0 ) * 'Dummy Key Figure') + (( 'Cumulative Value GC' <= 0 ) * 15)
If 'Cumulative Value GC' > 0.
rslt = 'Dummy Key Figure'.
else.
rslt = 15.
endif.
A True condition always evaluates to 1, a False condition evaluates to 0.
Thanks,
jlaruss
Answer:
thanks a lot