I have the following situation and been trying really hard to find a solution for the past couple of days to no avail. Right now i have two tables Delivery and Delivery_Details, the latter being part_of the former.
This is a simplification of the tables :
Delivery = Delivery id, Est. Total( This should be an app formula to calculate cost based on Est. Cost )
Delivery_Details = Delivery Details id, Delivery id, Location, Est. Cost ( Formula based on price per mile )
Assume the following example :
IDD1, ID1, 28 Lane, 20
IDD2, ID1, 28 Lane, 20
IDD3, ID1, 28 Lane, 20
IDD4, ID1, 56 Road, 30
IDD5, ID1, 86 Road, 50
In this example the Est. Total, shows 140 but i would like it to be 100 based on the fact that the first 3 rows are all going to the same address so the cost should only be taken into account once.
Is there any way i could do this with just a sum formula ? If not any workarounds i might be able to do ?