Closest Match Look Up

Posted by Joanne Penaflor on 02-Mar-2017 19:26

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. 

Corticon - Forum
Posted by Chris S. Hogan on 03-Mar-2017 11:15

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

[View:/cfs-file/__key/communityserver-discussions-components-files/14/4527.RangeExample.zip:109:45]

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

All Replies

Posted by Chris S. Hogan on 03-Mar-2017 11:15

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

[View:/cfs-file/__key/communityserver-discussions-components-files/14/4527.RangeExample.zip:109:45]

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

This thread is closed