variable not working in chart

[karolina_]

Hi All,

hope someone can help me with below problem

I have following variable vVar:

if(GetSelectedCount([Group])<>0,

Sum([Year 1])/GetSelectedCount([Group]),

Sum({<[Group]={$(vTarget)}>} [Year 1]))

I call it $(vVar) and it shows correctly in text box,but it does not apear at all in chart and table (both using valulist).

Note if I paste it directly in chart it's working ok.

If the last line (else filed) is different

if(GetSelectedCount([Group])<>0,

Sum([Year 1])/GetSelectedCount([Group]),

Sum([Year 1])/GetPossibleCount([Group]))
It's then working fine everywhere.

I tried to use

Sum( if([Group]=vTarget,[Year 1],0))

instead of

Sum({<[Group]={$(vTarget)}>} [Year 1]))

but it behave exactly the same

[sushil353 · Accepted solution]

Have u tried this:

f(GetSelectedCount([Group])<>0,

Sum([Year 1])/GetSelectedCount([Group]),

Sum({<[Group]={'$(vTarget)'}>} [Year 1]))

HTH

Sushil

[karolina_]

I have
$(vTarget)=Target

and I earlier tried $(vTarget)='Target'

After successfully checking your version i checked above again and it's working as well..

Thank you

edit: I have two more similar and were not working till i removed commented part of code in variable definition