Formula with Lookup

[Sophie_Watson]

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!

[Justin_Barrett]

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}

[Sophie_Watson]

Thanks Justin,
This worked perfectly.

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

Cheers for the help