Closest Match Look Up - Forum - Corticon - Progress Community

Closest Match Look Up

 Forum

Closest Match Look Up

This question is answered

Hi, 

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. 

Verified Answer
  • Using range value expression is the easiest way to address this.

    4527.RangeExample.zip

    The project attached shows an example of using ranges to determine closest value.

All Replies
  • Using range value expression is the easiest way to address this.

    4527.RangeExample.zip

    The project attached shows an example of using ranges to determine closest value.