Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
how can I create a pick / match combination which would give me 3 alternative.
pick(match(???,???),'-0.8',FACT.VALUE,'0.8')
"VALUE >=0.8" should give 0.8
"0.8 > VALUE > -0.8" should give the VALUE
"VALUE <= -0.8" should give -0.8
Best,
Dan
That's not what pick-match is for. You can use this instead: RangeMin(RangeMax(-0.8,FACT.VALUE),0.8)
But if you insist you can try Pick(1 + Match(-1, (FACT.VALUE < -0.8), (FACT.VALUE > 0.8)), FACT.VALUE, -0.8, 0.8)
That's not what pick-match is for. You can use this instead: RangeMin(RangeMax(-0.8,FACT.VALUE),0.8)
But if you insist you can try Pick(1 + Match(-1, (FACT.VALUE < -0.8), (FACT.VALUE > 0.8)), FACT.VALUE, -0.8, 0.8)