on 06-01-2015 5:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.