compoundcurves
New Member
- Joined
- Jul 12, 2021
- Messages
- 3
- Platform
- Windows
Hello guys!
Ive got a Facturation table that looks something like this :
Ive got two more tables, one for products that start with "X" and one for those that doesnt. Each of those tables got a row for every different code there is, and the idea is to summarize everything. I only need to summarize the units to those tables.
Both total tables are related to the Facturation one by the Code. Ive figured it out couple times but the problem is then I cannot multiply the Total Units with the Price as shown in the next table.
Ive got a Facturation table that looks something like this :
Product Code | Units | date | x | y |
4564 | 2 | . | . | . |
4564 | 3 | . | . | . |
4563 | 1 | . | . | . |
X456 | 1 | . | . | . |
X356 | 2 | . | . | . |
4563 | 4 | . | . | . |
X356 | 1 | . | . | . |
Ive got two more tables, one for products that start with "X" and one for those that doesnt. Each of those tables got a row for every different code there is, and the idea is to summarize everything. I only need to summarize the units to those tables.
Both total tables are related to the Facturation one by the Code. Ive figured it out couple times but the problem is then I cannot multiply the Total Units with the Price as shown in the next table.
Product Code | Price | Total Units | (Price * Units) |
X456 | 10.99 | 1 | 10.99 |
X356 | 10.99 | 3 | 32.97 |