Hello everyone!! I have a favor to ask for help and advice.
For stock apps, I have divided into 5 tables, tables 2 - 5 are sub-grids, connect the main tables, each table 2-5 has Lotno numbers, if Lotno numbers are the same, calculate their balance.
Table 1 Main table for sub-tables to be linked.
Table 2 Brought forward table
Table 3 Input table
Table 4 Output table
Table 5 Carry forward table
I would like to have a formula to exemplify. with carry forward to calculate the amount only of its lot But the formula I currently use is moving with every update. It's all included.
SUM(SELECT(Input_Wip_F[Q'ty_Input_F],[LotNo_Input_F]=[_THISROW].[LotNo_Input_F]))
+
SUM(SELECT(Wip_BF_F[Q'ty_BF_F],[LotNo_BF_F]=[_THISROW].[LotNo_Input_F]))
---------------------------------------------------- ------------------------------------------------
Required Calculations (I don't understand if I understand the term carry-forward, is that correct?)
Let's sort the important columns of each line, for example, 4 lines, 2 lines top and bottom. Models and Lotno are not the same, each model has multiple Lotno.
1) Date 7/6/2022 Model: 8520 Lotno : TEST0200 Table 2. Carrying amount = 0 Table 3.Input = 400 Table 4.Output = 300 Table 5. Carrying amount = 100
2) Date 8/6/2022 Model: 8520 Lotno : TEST0200 Table 2. Carrying amount = 100 Table 3.Input = 500 Table 4.Output = 200 Table 5. Carrying amount = 400
1) Date 7/6/2022 Model: 5520 Lotno : GDS2220 Table 2. Carrying amount = 0 Table 3.Input = 400 Table 4.Output = 200 Table 5. Carrying amount = 200
1) Date 7/6/2022 Model: 5520 Lotno : GDS2220 Table 2. Carrying amount = 200 Table 3.Input = 400 Table 4.Output = 200 Table 5. Carrying amount = 200
Tables in linked apps
----------------------------------------------------------------------------------
User | Count |
---|---|
33 | |
31 | |
30 | |
19 | |
17 |