Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please see attached simple application, I just want to get corresponding payment for each entity based on rate. It's kind like after monthly review, each entity has a rate, and in reference table each rate will have a payment. I want to show the payment for each entity.
It's just a look up, however I got some issue, if I use max, it will show max payment to all entities.
Thanks in advance.
This works - it looks a bit ugly though:
Pick(
Match( Rate ,
$(=Chr(39)&Concat(Num(mRate,'0.0'),Chr(39)&','&Chr(39),mRate)&Chr(39) ) )
,$(=Concat(Pay,',',mRate))
)