Can strings be used in BEx formulas?

[Former Member]

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

[ccc_ccc · Accepted solution]

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