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!
+21Welcome 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.