i have two tables, one is cost calculator and the other one is Parameter. i have the price in Dollar currency in the Cost calculator table and the Usd to euro transfere rate in the parameter table.
so i want to make the calculation between these two which is dividing dollar by the rate using expressions, to get the result in my cost calculator table in an other column.
so basicly my question is how to refer to a column in an other table and use it in a mathematical formula
I tried select and it said the expected result type should be Liste. meanwhile im using Price as date type. and to make calculation i need to use price type.
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โ)
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |