Dos anybody know why this expression is not working?

[#1]

I have in inbox that the label need to include the value of a variable. So following is the expression I wrote to the inbox box

='2.    ' & $(VARIABLE_1)+1 & ' to '

For Example:

If variable 1 is 10 than I am expected to see '2.   10 to'

But now what I got is only:

' to'

Does anyone know why it is not working?

Thanks in advance!

[#2]

Just a typo from my example,

If variable 1 is 10 than I am expected to see '2.   11 to'

But now what I got is only:

' to'

Thanks!

[tamilarasu]

Hi Elim,

Just add brackets like below,

='2.    ' & ($(VARIABLE_1)+1) & ' to '

If you want to add single quote around the output, then try,

=chr(39) & '2.    ' & ($(VARIABLE_1)+1) & ' to ' & chr(39)

Let me know.

[jagan · Accepted solution]

Hi,

Try like this

='2.    ' &  ($(VARIABLE_1) +1) & ' to '

OR

='2.    ' &  $(VARIABLE_1 +1 ) & ' to '

Hope this helps you.

Regards,

jagan.

[Anonymous]

Try this...