Using a linked field in a formula

[Danae_Daniilidi]

Good morning,

I am trying to use an FX rate (which is a lookup field from another table) and a number value in a function. I have been using VALUE({FX}) * {Equity} where FX is the lookup fields and Equity is a number field. I am getting an Error for all lines and no error explanation.

Does anyone know how to fix this?

Thanks!

[Nathalie_Collin]

Hi @Danae_Daniilidis and welcome to Airtable Community :smiling_face_with_three_hearts:

Your formula is a good one. Can you provide screenshots?

[Danae_Daniilidi]

Hi Nathalie, I managed to get the formula to work by changing the data type of the field that was being pulled in the linked table to number instead of text! Thank you for your help!