Forum Discussion
Piet
8 years agoFrequent Visitor
Multiple two different columns from two different tables
Hello, i think it is a simple question : Hwo can i multiple two different columns (cost * sales_quanity) from two different tables: table1 item cost 4711 99,90 table2 item s...
- 8 years ago
Hi Piet,
That's should be easy if you could create a relationship between the two tables.
Have you solved the problem with the answers from quentin_vigne and alexei7?
If you have solved, only thing that you'll have to notice, just always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
- 8 years ago
it works.
thanks a lot
Piet
quentin_vigne
8 years agoSolution Sage
Hi Piet
If there is a joint between your 2 tables the formula will be :
Cost-gross = table1[cost] * table2[sales_quantity]
- Quentin