As title would suggest. i’m trying to return a value from a datatable after inputting a value. this inputted value is a number that is between a Min and a Max value. one problem i have is that the datatable has 4 key indicators that all have there own seperate min/maxes and carriage prices.
Any ideas of how i can get the return i want from the Carriage column, depending on the input value?
I presume it’ll use a Lookup Datatable activity. but not quite sure how to build it.
Thanks for help.