How to use a variable in chart expresion ?

[yanivvl0]

hello to all the QV Climbing  ,

i have an expression : sum (  aggr (  max  (  {$<Subject={1}>}  if (  type38=1 or type39=1 ,  amount , 0  )      )  , proj_code  )  )

and i want to make it dynamic by usin a variable :  vIfAmount = if (  type38=1 or type39=1 ,  amount , 0  )   

in:

sum (  aggr (  max  (  {$<Subject={1}>}  $(vIfAmount)      )  , proj_code  )  )

but i get 0  :

is there any way to make the calculation work ?

thanks .

[sunny_talwar · Accepted solution]

Not sure what your exact requirement is, but try the attached

[yanivvl0]

thanks

[jonathandienst]

The variable had no value in it,. If you assign the variable to your expression, it works correctly.

[sunny_talwar]

No problem at all

[yanivvl0]

yea , i wrote with = , and then i delete ..