# 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

##### Nanda Anantha 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