Single cost creation

The panel below has 3 columns the first 2 are inputs the 3rd is the desired outcome. The given data is Load Number and Freight Cost, the Shipment Cost is the desired outcome which I have generated by a if statement looking at the next row of data and selecting a single value of Freight Cost for that shipment. How do I this in EDT Thanks

Unfill is your friend.

shipment.transform (2.6 KB)

1 Like

Thanks it worked very well

1 Like