In my quote form, the user selects a Depot location (zip code) and destination (zip code) which calculates the total mileage (distance). In order to determine the shipping rate to use for calculating shipping costs, the system needs to find the correct rate in the Depot Rates table for the selected Depot ID where the mileage calculated falls between a range of miles. (if calculated mileage falls between the start mileage and end mileage, select the rate).
When I use the expression below, it appears to work correctly when I press the Test option but doesn’t appear on screen. I’ve tried the expression in the initial value of my Shipping Mileage Rate field and app formula and none appear on screen. Is the expression correct?
Shipping Mileage Rate:
ANY(SELECT(Depot Rates[rate],AND([depot]=[_THISROW].[depot],[_THISROW].[vir_mileage]>=[start mileage],[_THISROW].[vir_mileage]<=[end mileage])))
Depot Rates table: