Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)'))
This one should work:
=$(vTranslate('province_$(vScenario)'))
This one should work:
=$(vTranslate('province_$(vScenario)'))
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,