Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Can strings be used in BEx formulas?

I created a replacement value formula variable on another user input variable, which is based on a text InfoObject.  I would like to use this formula variable in a BEx formula as an "if" statement, but the formula window doesn't allow me to type a character string.

For example, suppose I have user input variable called VarUserInput.  My formula variable is called VarFormula.  The variable VarFormula shows the value of VarUserInput.  For example, if VarUserInput = "ABC", then the value of VarFormula should be "ABC" as well.

I would like to use the following formula:


Is there a way to do this formula in BEx QueryDesigner 7.0?  I wasn't able to type a character string in the formula.  I find this strange, since replacement value variables can be defined to use the text label of the variable, which is a character string by default.

Thank you in advance for your help.



Hi Naida,

We cannot handle string operations in BEx designer.

Instead of ABC you may take 1 or 2.

(VarFormula=='1')*1. this is possible.

Thank you,


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question