Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have u tried this:
f(GetSelectedCount([Group])<>0,
Sum([Year 1])/GetSelectedCount([Group]),
Sum({<[Group]={'$(vTarget)'}>} [Year 1]))
HTH
Sushil
Have u tried this:
f(GetSelectedCount([Group])<>0,
Sum([Year 1])/GetSelectedCount([Group]),
Sum({<[Group]={'$(vTarget)'}>} [Year 1]))
HTH
Sushil
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