Forum Discussion
Recipe usage
Hi, I have this table with recipes: Table 1 Product Raw material Amount 1 3 0.3 1 4 0.3 1 5 0.3 2 3 1 2 5 3 2 6 6 And another table (Table2) with pl...
Hi sw123 ,
Could you please provide more sample data and expected result with specific examples and calculation logic? Do you need to get the count of Raw material? Thank you.
Best Regards
Hi,
Here is an example of data (recipe):
| Product ID | Planned production amount | Raw material ID | Needed raw material / kg | SUM of needed raw material |
| 1 | 1000 | A | 0.003 | 3 |
| 1 | 1000 | B | 0.035 | 35 |
| 1 | 1000 | C | 0.04 | 40 |
| 2 | 20000 | A | 0.003 | 60 |
| 2 | 20000 | B | 0.03 | 600 |
| 2 | 20000 | C | 0.04 | 800 |
What I want to do is simply calculate how much of raw materials A, B and C I need for producing products 1 and 2. Like this:
| Raw material | Needed amount of raw material |
| A | 6883,8798 |
| B | 6125 |
| C | 3290,0315 |
Does this help?