I have a problem I am tracking units delivered into 4 categories. I created a field for each category and if they get a delivery a 1 or 2 is placed in the boxes that was delivered. When we bill I sum the totals of each field and multiply the sales price.
Except when they get a delivery of box 1 and box 2 together. Then I need to give them a special price. So ... if
box 1 they get 20 delivered and box 2 they get 15 delivered I need to calculate this way.
Combined box 1 and 2 15 * 7.75= 116.25
in Addition I need 5 * 4.50 = 22.50
So the total of the boxes would be $138.50
I can do it if Box 1 and Box 2 are equal no problem but if Box 1 and box 2 are not I run into my complication.
I have to have it as a separate calculated field so I can mail merge it to my word files for the bill..