Expression Question

[zwyne]

Hello,

PFA

I have asked this question earlier on and I was correctly answered, but now when I add other  expressions I don't get the desired result. Instead of getting 

Issue Rule                               Major Score     Limited Score

<79% Limited issues                                                12

>21% Major issues                          14                                      

I get the wrong result as  per the attached sample model.

Please assist again.

Thanks

[sunny_talwar · Accepted solution]

It was my bad for removing part of your expression... this should work

Pick(Match(Issue_Rule,'<79% Limited issues','80-89% Limited issues','>90% Limited issues'),
if($(eCntLtdCurr%) < 0.79,12),
if($(eCntLtdCurr%) >= 0.79 and $(eCntLtdCurr%)<=0.89, 8),
if($(eCntLtdCurr%)>=0.9,5))

and this

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

[zwyne]

Thank very much, I have included more expressions and it works nicely