Skip to Content
0
Former Member
Jun 01, 2015 at 04:27 PM

Can strings be used in BEx formulas?

201 Views

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