Hello, I have a quote that calculates pricing based on the depot the item is shipping from. In the past the user selects the depot and inputs a destination zip code and the system runs the mileage based on the distance between zip codes. We’d like the quote to now “automatically” select the NEAREST depot to the destination being entered (vs. selecting the depot) and then proceed with the regular calculations.
Now to determine the nearest Depot (Depot initial value), I created a virtual field in the quote but I’m getting the error below - can someone assist with the right expression?
User | Count |
---|---|
43 | |
28 | |
24 | |
21 | |
13 |