Variable in a dimension not working :-(

[#1]

Hi All,

I have a dimension.. where vThisWeek is a variable

if (SalesWeek= vThisWeek,'Yes')

which works fine, but then I want to change it using a macro and hence want to use another variable i.e.

vReportNeeded =    vThisWeek OR SalesWeek = vLastWeek

and then have if( SalesWeek=vReportNeeded, 'Yes') but it doesn't seem to work and produces no figures.

I ant to throw various week values at it, hence the variable

Anyone any ideas please ?

Thanks in advance

Bob

[fkeuroglian]

Hi, using macro you have to get and set value from variables, not using =

i put an example

good luck

get value from variable:

set vFromDateTransito = ActiveDocument.Variables("vFromDateTransito")

set value:

set ValorVariable = ActiveDocument.Variables("vTest2")      

          v = "1"   

          ValorVariable.SetContent v , true

[#3]

Hi thanks for the reply but it does nto help I am afraid.

I have a macro that sets the variable, but after it has set the variable the dimnesion will still not produce figures from it

[SunilChauhan · Accepted solution]

use with $ sign

and in dimension  use like '$(Variable name)'

[#5]

How frustratiingly simple - thank you !! 🙂