Forum Discussion

X3svfdB1HOjKYc0's avatar
X3svfdB1HOjKYc0
Regular Visitor
4 years ago

Trouble With Links/Formulas

I have two tables. The first table is a list of containers, charge codes and amounts. See sample table with charges totalling 1400.

 

 

The second table is a list of containers, order lines and physical volume. There is a many-to-many relationship between these tables.

 

 

I want to setup a formula that will allocate the freight costs pro rata based on the volume as show below.

 

I just can't seem to get the bridge table and formulas right for this. Any help would be very much appeciated.

 

I also want to set this up in a way where I can link addition information to the container (many from this results table to a single key in the container table) and also additional order information (again, many from this results table to a single key in the order table). I don't think this will be an issue but just wanted to make sure that any solution keeps this in mind.

 

3 Replies

  • X3svfdB1HOjKYc0's avatar
    X3svfdB1HOjKYc0
    Regular Visitor
    4 years ago

    Thanks for your help getting the inital table merged. This is already a big step forward. 

     

    Edited and updated from earlier post. I am now getting a result that is not an error, however the values seem to be divided by the volume an extra time.

     

    I could take the result and multiply it again by the volume to force the correct solution, but, is there a more elegant way to get the original formula?