How to Merge 2 Variables

[priyarane]

Hi Community,

I wanted to merge 2 variables like below.

=$(vExp_ACCR_INCOME_DRAWN)  /   $(vDenominationValue)

I have tried like below

=$(vExp_ACCR_INCOME_DRAWN)   $(=chr47)) &   $(vDenominationValue)

but not worked out.

How to do '/'

[MK_QSL]

Isn't this working ?

Variable1 & '/' & Variable2

[priyarane]

no

[amit_saini]

Check

Thanks,
AS

[mpbtejada]

Are you intending to return a text value or to compute a formula?

If you want text, encapsulate the variables in single quotes.

'$(vExp_ACCR_INCOME_DRAWN)'  & '/' & '$(vDenominationValue)'

[amit_saini · Accepted solution]

Try,

=($(vExp_ACCR_INCOME_DRAWN) ) /   ($(vDenominationValue) )

I think brackets are missing.

Thanks,AS

[amit_saini]

This should work:

num(

     ($(vExp_ACCR_INCOME_DRAWN) ) / ($(vDenominationValue) )

     ,'###.###,')

Thanks,
AS