Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
Perfect, thank you.