How to create formula in variable field for button?

[tonytang]

Hi,

Is there any way to construct a formula in the variable field for button? I found it doesnt work. My purpose is very simple. If the variable (vCurr=1), then i use the column  [Product Category] to get, otherwise i use Product Sub-Category to get value. 

But, the function does not work. Is there any way to achieve the effect?

Thanks

[MayilVahanan · Accepted solution]

HI 

Try like below

=if(vCurr = 1, '[Product Category]', '[Product Sub-Category]')

Use the vFieldName variable where its required like below

$(vFieldName)

[tonytang]

it works. Thx