Automation query

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: 

Nadhirah_3-1709689098799.png

Nadhirah_0-1709688868237.png

Result Formula 1:

Nadhirah_1-1709688893249.png

Result Formula 2:

Nadhirah_2-1709688902055.png

Table example which I took it from:

UniqueIDPart DescriptionUnitPart imageCategorySub CategoryInitial StockStock InStock OutCurrent StockMinimum LevelMaximum LevelReorder LevelStatusColour
1GARBAGE BAG (XL)PCS HousekeepingMaterials1050 400650502000500Above Reorder LevelGreen
2GARBAGE BAG (L)PACKET HousekeepingMaterials69 0695040080Reorder LevelYellow
3GARBAGE BAG (S)PACKET HousekeepingMaterials683 06835050050Above Reorder LevelGreen
4MP 10 (20L)LITRE HousekeepingChemical96 096105010Above Reorder LevelGreen
5FLORAL DISINFECTANT (20L)LITRE HousekeepingChemical41 932105010Above Reorder LevelGreen
6GLASS CLEANER / SCENIC VLITRE HousekeepingChemical71 566105010Above Reorder LevelGreen
7SAVONA D2 (20L)LITRE HousekeepingChemical80 1466105010Above Reorder LevelGreen
8HAND SOAP APPLELITRE HousekeepingChemical80 156555010Above Reorder LevelGreen
9STRAWBERRY FRESHENERLITRE HousekeepingChemical40 192155010Above Reorder LevelGreen

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. 

0 0 56
0 REPLIES 0
Top Labels in this Space