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:

(VarFormula=='ABC')*1.

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.

Nadia

Former Member
replied

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,

Nanda


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