Hi @Savana_Groups! Yes, SELECT() produces a list.
I don’t understand why your “Price” is a date type column. I think it should be a number or a price column. In what follows, I’ll assume it’s a price column.
I don’t know the structure of your tables so it’s a little hard for me to advise you about how best to get the information from your Parameter table into your Cost calculator table. Let’s try to get you started by assuming that all of the transactions in your Cost calculator table in your “Price” column are in US dollars and the Parameter table has the following two columns: “Convert to” (a text column that indicates the name of the currency to convert US dollars to) and “Rate” (a number column with the conversion rate for that currency). “Euro” inside the “Convert to” column indicates that this row has the conversion rate for dollars to Euros.
Now, you should be able to make a virtual column in your Cost calculator table with the following expression to do the calculation:
[Price]*LOOKUP(“Euro”, “Parameter”, “Convert to”, “Rate”)