pick match

[dberkesacn]

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

[Gysbert_Wassenaar · Accepted solution]

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)