Skip to main content

Hi All,


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.


Thanks everyone!

Welcome to the community, Sophie! A lookup returns an array, even when it’s just a single item in the array. To work with that, you need to convert it to a string, which can be done by concatenating it with an empty string. The whole formula might look like this (using field names based on your example):


VALUE({Cost per Unit} & "") * {Quantity Ordered}

Thanks Justin,

This worked perfectly.


I almost had it, I was just missing the empty string!


Cheers for the help

Terms & Conditions