Forum Discussion
IN/OUT calcule
Hello,
I want to calculat the IN and OUT of my stock for 1 week.
I have already try that but it's more complicated than we think.
For exemple I have this table:
| Article | Name article | Week In | Week out |
| 9B | Motor | 2023-01 | 2023-03 |
| 9D | wheel | 2023-01 | |
| 9G | drive shaft | 2023-01 | 2023-03 |
| 9R | Pinion | 2023-01 | 2023-01 |
| 9E | reserve | 2023-01 |
In this case I want to count all OUT in 2023-03 week and all IN in 2023-03 week. After that I want to calcule CURRENT measure which equals the sum of all IN <= current week less than the sum of all OUT <= current week.
If we take the 2023-01 week we obtain: 5 IN & 1 OUT so CURRENT = 4.
I hope than someone can help me because I block on this problem and I don't find a solution.
Sincerly,
Imad RACHATI.
