Skip to Content
0
Jan 18, 2012 at 09:12 AM

Formula to return Text

741 Views

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