I am new to Airtable and struggling with getting a total (extended cost) for my purchase order which includes a lookup.
All I am after is: Cost per Unit (ex gst) * Quantity Ordered = Total Price (ex gst) for the individual row. (not the sum at the bottom)
ie 10 items x $5.00(lookup) = $50.00
Cost per unit is a lookup from the Product inventory table.