Evaluation of SET expression variable

[Anonymous]

Hi,

I have a variable created in my application using SET keyword whose value has a special character.

Example : SET vSample='Sp-Char'

                SET vSample2='SampleVal'

When I am using this variable value in my SET analysis expression it is not returning the correct value where as the another variable vSample2 is returning the proper value.

PFA sample application. In this application the set analysis expression for the value without special character is working fine(expression for text box background color)  where as the variable with value without special character is not working.

Hope I am clear on my part.

Thanks in advance.

Regards,

Laxmi

[alexandros17]

what are you trying to do?
First you cannot use (Sum( ...Value) if value is not numeric.
second in field description you cannot use - char, try with SP_Char
Third when you use Sum for colours choice in text boxes, which value should you use?

Hope this helps

[Anonymous]

Thanks for you time Alessandro Saccone.

My actual application with (Sum(.. Value) has a numeric value.

Sorry I cannot post my application as it has confidential data.

Let me explain in a different way.

I have different Business Units in my firm.

vBU1='Unit1'

vBU2='Unit2'

vBU3='Unit3'

And if a particular Business Unit has not met the target a flag will be set to -1 else it will be 0. Let this flag be BUFlag.

The text box color should be red or green based on this flag value for different Business Units. If the flag is -1 it will red or it will be green if its 0.

Condition in the textbox would be

if(SUM({<BU={$(vBU1)}>}BUFlag)=-1,red(),green())

Hope I am not confusing...

Regards,

Laxmi

[avinashelite]

try like this:

if(if(BU=$(vBU1),sum(BUFlag))=-1,red(),green())

[rubenmarin]

Hi Laxmi, You can try with:

=sum({<Value={'$(vSample)'}>}Value)

without the quotes i think qv is trying to do Sp minus Char

[Anonymous]

Thanks all for your reply.

This helps.

But is there any way that I can implement while setting the variable value?

Because I have hundreds of such expression where I have to make the changes. Instead I want to change the value of variable in SET.

Regards,

Laxmi

[rubenmarin]

Hi, try with:

SET vSample="'SP-Char'";

This a a simple-quoted text inside a double-quote.

[Anonymous]

have you tried in place of -1 just use

if(SUM({<BU={$(vBU1)}>}BUFlag)<0,red(),green())

[alexandros17]

The problem is in

if(SUM({<BU={$(vBU1)}>}BUFlag)=-1,red(),green()) ...