Text Results in formula

[Former Member]

Hello All,

Could someone please advise of the best way to return text from a formula result. An example would be if we want to return "Incorrect Material" as a formula result if rejection reason on a sales order is equal to "01". Any help would be greatly appreciated.

Thanks

[alfonso_gonzalez2]

Hi.

I think this is not somethign that can be done stright forward.

Are you using WAD or BEX? If you are using WAD, you might be able to return in the formula some specific value (for example 999999) and then with the table interface you can replace that value with the corresponding text.

If you are using bex query, then you can create a macro that substitute the value 99999 by the text.

this is all that comes to my mind. I hope it helps.

regards.

[Former Member]

Thanks for your help. We are using Bex Analyzer.

[Former Member]

Hi,

Well, that's the same I was looking for a couple of days ago and unfortunately I couldnt find something comfortable.

Using Query Designer you can replace the value '0' with any text of your choice. But then if you are looking for a text for a value other than zero...then you may not find a starightforward way.

Regards

Shalabh