Hi,
I have created a formula in Key Figures and wrote an if-else in Bex Designer and it works fine when i return a number for any condition.
My formula presently working is:
('Z_FINISH_DATE' > 'CURRENT_DAY') * 5 + ('Z_FINISH_DATE' < 'CURRENT_DAY') * 25
When i run the query in Web Bex Analyzer it return 5 and 25 depending on the condition.
I want to replace these numbers with text like 'Overdue' and " In Process'.
My only requirement is that for any condition, i want to return text.
Best Regards
Faisal khan