Expresion Question

[zwyne]

Hello everyone,

PFA,

Please assist me with this expression below

Pick(Match(Issue_Rule,'<10% Major issues','11 -20% Major issues','>21% Major issues'),
  if($(eCntMajCurr%)< 0.1,7),
  if($(eCntMajCurr%)=>0.11 and $(eCntMajCurr%)<=0.20),
  if($(eCntMajCurr%)>=0.21,14))

In my chart I am expecting this result

Issue_Rule                               Score 

>21% Major issues                   14

My Pick Match function is not working , please assist

Thanks

[sunny_talwar]

Try this

Pick(Match(Issue_Rule,'<10% Major issues','11 -20% Major issues','>21% Major issues'),
if($(eCntMajCurr%) < 0.1,7),
if($(eCntMajCurr%)<=0.20, 10.5),
if($(eCntMajCurr%)>=0.21,14))

[sunny_talwar · Accepted solution]

I added 10.5 for the 11-20% Major issues because your original expression didn't have any value for it. Feel free to change it to 0 or another value.

[zwyne]

Perfect, thank you.