Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
Try like this
='2. ' & ($(VARIABLE_1) +1) & ' to '
OR
='2. ' & $(VARIABLE_1 +1 ) & ' to '
Hope this helps you.
Regards,
jagan.
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!
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.
Hi,
Try like this
='2. ' & ($(VARIABLE_1) +1) & ' to '
OR
='2. ' & $(VARIABLE_1 +1 ) & ' to '
Hope this helps you.
Regards,
jagan.
Try this...