Has anyone done a closest match look up in Corticon.
I am trying to create a rulesheet that will tell me the rate the corresponds a Sum Insured amount, and the rate returned should be the closest match, just like how a vlookup with closest match set to true works.
Thanks in advance.
Using range value expression is the easiest way to address this.
The project attached shows an example of using ranges to determine closest value.