Hi,
ok so I have this database 'Process Production':
| ID Product | No. Process | Process | Hours |
| 1ABC | 10 | kfdsmkfsl | 1 |
| 1ABC | 20 | dklafklamdf | 1.5 |
| 1ABC | 30 | dasdlafndlf; | 2 |
| 1ABC | 35 | alkslafmldaf | 1 |
| 1ABC | 40 | nksalkdjla | 1 |
| 2FRW | 20 | kdlsjfadnf | 2 |
| 2FRW | 30 | sdnkafmlaf | 3.5 |
| 2FRW | 40 | djklaflada | 10 |
| 2FRW | 50 | sdkaflad | 2.5 |
and I have another SharePoint List ('Tracking Process') to record the process, but the history process will be replaced to the new one. But I want to count the hours with the processes I've passed. Because the process not always based on 'No. Process'.
For now, I used this formula:
Round((Sum(Filter(AllRecapSOW, 'ID Product' =ThisItem.'ID Product' && 'No. Process' < ThisItem.'No. Process'),Hours)) / (Sum(Filter(AllRecapSOW, 'ID Product' =ThisItem.'ID Product'),Hours)) * 100,2) & " " & "%"
Note:
There's nothing wrong with formula, but the formula just work for flow like this:
-the first process that already submitted in SP list "Tracking Process" is No. Process 20.
then when,
1. I choose ID 2FRW and No. Process 40 from database AllRekapSOW as second step
2. I submit that data to my SP list (lets call it "Tracking Process"), so the previous data (No. Process 20) will be replaced by No, Process 40.
3. then, the label in gallery which is displayed the %progress will calculate like:
(2+3.5) / total hours ID 2FRW.
Thats not what I want, because No. Process 30 has not been passed. Its should be,
(2) / total hours ID 2FRW.
So, I want to know, how to revision the formula so I get flow what I want. Can you help me? Thank you
