Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have columns like TOT_SLS_DLR, PUBLIC_SLS_DLR, PRIV_SLS_DLR,etc..
There is a list box which assigns the value 'TOT_' , 'PUBLIC_' and 'PRIV_' to a variable say v1.
I need to use something like sum($(v1)&'SLS_DLR') in my expression. How can we do this??
(assigning 'SLS_DLR' to another variable will not work in my case.)
Thanks in advance
-Aditya
you can try like this sum($(v1)) & 'SLS_DLR'
Regards,
P.Prasath
Hi Aditya:
Hope the attached App would help.
Thanks,
Narasimha K
Thanks for the solution.
-Aditya
Hi Narsimha
Is there a way to use the variablename or fieldname('=Type' in case of your qvw) in between two strings??
Ex. $(=Type&'_SLS_AMT') ->This is what we have used right now.
I need something like -> $('LCK_'&Type&'_SLS_AMT')
Hi Aditya:
See the attached QVW. Hope that helps.
I think you are missing an equl sign before left parenthesis, your expression should be - $(='LCK_'&Type&'_SLS_AMT')
Thanks,
Narasimha K