Hello, I am trying to make calculation using 2 columns from different tables.
For ex. I have formulas table. In that table there are formulaId, component_name, qty. And another table “prodcution”, where there is formuladId column. and some other not imporant. I have also “total” column there.
What I want is In the table “Formulas” multiply “qty” column by “production. total” value.
How can I combine the 2 tables to count?
How would you know which rows of the two tables to get the column values from for the calculation?
For example. In the production table I have a column formulaid, the same colum is related to formulas table.
I tried to use filter expresion. However don’t know how to manage with arithmetic expresion.
Roman
sob., 21 lis 2020, 14:23 użytkownik Steve Coile via AppSheet Creator Community <appsheet@discoursemail.com> napisał:
User | Count |
---|---|
43 | |
29 | |
23 | |
21 | |
13 |