Variable Expressions

[ss09]

WORKS=$(vTranslate('province_ps1d')) -> This gives me all my provinces for the table.

However, I would want to refer either province_ps1d or province_ps2d.

Attempt 1 - Not working

$(vScenario) = 'ps1d'
=$(vTranslate('province_' & $(vScenario)))

Attempt 2 - Not working

$(vScenario) = 'ps1d'
=$(vTranslate('province_' & '$(vScenario)'))

[vincent_ardiet_ · Accepted solution]

This one should work:
=$(vTranslate('province_$(vScenario)'))

[Happy_Mask_Salesman]

Hi.

Attempt 2 is working for me.

Where vSufijo is 'd'.

=$(vTest('ps1' & '$(vSufijo)' ))

vTest formula. If the first parameter equals 'psd1', say yes, if it doesn't, return a 'no'.

if( $1 = 'ps1d',
'yes',
'no')

Would you provide us the formula for vTranslate?

I also can suggest you to use double quotes.

PD: Sorry, didn't see Vincent answer yet.
Regards,