Hi everyone, I am having some problem to understand certain query.
For my project, I want the current stock for every month to be stored in other table to keep track of the past month stock quantity.
Right now, I have two formulas which returns value but one gives an array with comma and another one gives the correct syntax however if I use this way, it is not usable as it uses uniqueID for table A to go to table B but I want table B to store data for every month.
Here is the details:
Formula:
Result Formula 1:
Result Formula 2:
Table example which I took it from:
UniqueID | Part Description | Unit | Part image | Category | Sub Category | Initial Stock | Stock In | Stock Out | Current Stock | Minimum Level | Maximum Level | Reorder Level | Status | Colour |
1 | GARBAGE BAG (XL) | PCS | Housekeeping | Materials | 1050 | 400 | 650 | 50 | 2000 | 500 | Above Reorder Level | Green | ||
2 | GARBAGE BAG (L) | PACKET | Housekeeping | Materials | 69 | 0 | 69 | 50 | 400 | 80 | Reorder Level | Yellow | ||
3 | GARBAGE BAG (S) | PACKET | Housekeeping | Materials | 683 | 0 | 683 | 50 | 500 | 50 | Above Reorder Level | Green | ||
4 | MP 10 (20L) | LITRE | Housekeeping | Chemical | 96 | 0 | 96 | 10 | 50 | 10 | Above Reorder Level | Green | ||
5 | FLORAL DISINFECTANT (20L) | LITRE | Housekeeping | Chemical | 41 | 9 | 32 | 10 | 50 | 10 | Above Reorder Level | Green | ||
6 | GLASS CLEANER / SCENIC V | LITRE | Housekeeping | Chemical | 71 | 5 | 66 | 10 | 50 | 10 | Above Reorder Level | Green | ||
7 | SAVONA D2 (20L) | LITRE | Housekeeping | Chemical | 80 | 14 | 66 | 10 | 50 | 10 | Above Reorder Level | Green | ||
8 | HAND SOAP APPLE | LITRE | Housekeeping | Chemical | 80 | 15 | 65 | 5 | 50 | 10 | Above Reorder Level | Green | ||
9 | STRAWBERRY FRESHENER | LITRE | Housekeeping | Chemical | 40 | 19 | 21 | 5 | 50 | 10 | Above Reorder Level | Green |
Above is table A. The picture of results is table B. I need some ideas to make the data of the table stored in another table every month by adding new rows instead of using uniqueID since Table A [part description] wont be updated.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |