topic Re: Expression Question in Water Cooler

Expression Question

zwyne — Mon, 17 Dec 2018 20:18:30 GMT

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

Re: Expression Question

sunny_talwar — Mon, 17 Dec 2018 20:42:51 GMT

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))

Re: Expression Question

zwyne — Tue, 18 Dec 2018 05:31:11 GMT

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