Calculating a fee based on QTY delivered and total fee outstanding

Stitched

I am looking to calculate a fee amount based on total fee and qty delivered. For example, if I have two items on a PO, but only one delivers, the Fee to be Paid would only be half of the total. If all items deliver, the "Total Admin Fee" would copy over to "Admin Fee to be Paid".

In the snip below, for the highlighted row, the "Admin Fee to be Paid" should be $75 (total admin fee/4=75. One item of 4 was delivered). If 2 of 3 had delivered, $150, 3 of the 4 it would be $225, etc.

Kelly Moore

Hey @Stitched

Try this in your [Admin Fee to be Paid] column

=[Total Admin Fee]@row * [Quantity Delivered]@row / [Quantity Ordered]@row

Will this work for you?

Kelly@Robert Harrison

Kelly Moore

Hey @Stitched

Try this in your [Admin Fee to be Paid] column

=[Total Admin Fee]@row * [Quantity Delivered]@row / [Quantity Ordered]@row

Will this work for you?

Kelly@Robert Harrison

Stitched

Worked beautifully! Thank you!