Forum Discussion
Calculating data from another table - Not Simple!!
Hey There, So here it goes: 1. I have a table called "WeekData" (the first image) 2. The data in the "WeekData" comes from a dump CSV file - So far so good! 3. Check out the first image the da...
Hi Beyondforce
Looks do-able. Any chance you can post some sample data in the form of text and not an image so we can use it to build a prototype model? This is just to save lots of typing in. :)
Sure Phil_Seamark, here you go:
| WeekNumber | TransactionDate | BlockDate | BlockName | LateStart | LateEnd | OVERTRÆK | Month1 | Status | Month | Day |
| 9 | 1. marts 2017 | 1. marts 2017 | Batch 40 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 1. marts 2017 | 1. marts 2017 | Batch 60 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 1. marts 2017 | 2. marts 2017 | Batch 10 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 1. marts 2017 | 1. marts 2017 | Batch 20 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 1. marts 2017 | 1. marts 2017 | Batch 30 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 1. marts 2017 | 1. marts 2017 | Batch 35 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 1. marts 2017 | 1. marts 2017 | Batch 33 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 1. marts 2017 | 1. marts 2017 | Batch 65 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 1. marts 2017 | 1. marts 2017 | Batch 45 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 1. marts 2017 | 1. marts 2017 | Batch 50 | 0 | 0 | N | marts | 0 | March | 01 |
| 9 | 2. marts 2017 | 2. marts 2017 | Batch 50 | 0 | 0 | N | marts | 0 | March | 02 |
| 9 | 2. marts 2017 | 3. marts 2017 | Batch 10 | 0 | 0 | N | marts | 0 | March | 02 |
| 9 | 2. marts 2017 | 2. marts 2017 | Batch 65 | 0 | 0 | N | marts | 0 | March | 02 |
| 9 | 2. marts 2017 | 2. marts 2017 | Batch 45 | 0 | 0 | N | marts | 0 | March | 02 |
| 9 | 2. marts 2017 | 2. marts 2017 | Batch 35 | 0 | 0 | N | marts | 0 | March | 02 |
| 9 | 2. marts 2017 | 2. marts 2017 | Batch 60 | 0 | 0 | N | marts | 0 | March | 02 |
| 9 | 2. marts 2017 | 2. marts 2017 | Batch 40 | 0 | 0 | N | marts | 0 | March | 02 |
| 9 | 2. marts 2017 | 2. marts 2017 | Batch 33 | 0 | 0 | N | marts | 0 | March | 02 |
| 9 | 3. marts 2017 | 3. marts 2017 | Batch 35 | 0 | 0 | N | marts | 0 | March | 03 |
| 9 | 3. marts 2017 | 3. marts 2017 | Batch 60 | 0 | 0 | N | marts | 0 | March | 03 |
| 9 | 3. marts 2017 | 3. marts 2017 | Batch 40 | 0 | 0 | N | marts | 0 | March | 03 |
| 9 | 3. marts 2017 | 3. marts 2017 | Batch 33 | 0 | 0 | N | marts | 0 | March | 03 |
| 9 | 3. marts 2017 | 3. marts 2017 | Batch 50 | 0 | 0 | N | marts | 0 | March | 03 |
| 9 | 3. marts 2017 | 3. marts 2017 | Batch 20 | 0 | 0 | N | marts | 0 | March | 03 |
| 9 | 3. marts 2017 | 3. marts 2017 | Batch 30 | 0 | 0 | N | marts | 0 | March | 03 |
| 9 | 3. marts 2017 | 3. marts 2017 | Batch 65 | 0 | 0 | N | marts | 0 | March | 03 |
| 9 | 3. marts 2017 | 3. marts 2017 | Batch 45 | 0 | 0 | N | marts | 0 | March | 03 |
| 10 | 3. marts 2017 | 6. marts 2017 | Batch 10 | 0 | 0 | N | marts | 0 | March | 03 |
| 10 | 6. marts 2017 | 6. marts 2017 | Batch 30 | 0 | 0 | N | marts | 0 | March | 06 |
| 10 | 6. marts 2017 | 6. marts 2017 | Batch 40 | 0 | 0 | N | marts | 0 | March | 06 |
| 10 | 6. marts 2017 | 6. marts 2017 | Batch 60 | 0 | 0 | N | marts | 0 | March | 06 |
| 10 | 6. marts 2017 | 6. marts 2017 | Batch 50 | 0 | 0 | N | marts | 0 | March | 06 |
| 10 | 6. marts 2017 | 7. marts 2017 | Batch 10 | 0 | 0 | N | marts | 0 | March | 06 |
| 10 | 6. marts 2017 | 6. marts 2017 | Batch 33 | 0 | 0 | N | marts | 0 | March | 06 |
| 10 | 6. marts 2017 | 6. marts 2017 | Batch 35 | 0 | 0 | N | marts | 0 | March | 06 |
| 10 | 7. marts 2017 | 7. marts 2017 | Batch 20 | 0 | 0 | N | marts | 0 | March | 07 |
| 10 | 7. marts 2017 | 7. marts 2017 | Batch 30 | 0 | 0 | N | marts | 0 | March | 07 |
| 10 | 7. marts 2017 | 7. marts 2017 | Batch 40 | 0 | 0 | N | marts | 0 | March | 07 |
| 10 | 7. marts 2017 | 7. marts 2017 | Batch 60 | 0 | 0 | N | marts | 0 | March | 07 |
| 10 | 7. marts 2017 | 7. marts 2017 | Batch 45 | 0 | 0 | N | marts | 0 | March | 07 |
| 10 | 7. marts 2017 | 7. marts 2017 | Batch 50 | 0 | 0 | N | marts | 0 | March | 07 |
| 10 | 7. marts 2017 | 7. marts 2017 | Batch 65 | 0 | 0 | N | marts | 0 | March | 07 |
| 10 | 7. marts 2017 | 7. marts 2017 | Batch 33 | 0 | 0 | N | marts | 0 | March | 07 |
| 10 | 7. marts 2017 | 7. marts 2017 | Batch 35 | 0 | 0 | N | marts | 0 | March | 07 |
| 10 | 8. marts 2017 | 8. marts 2017 | Batch 70 | 0 | 0 | N | marts | 0 | March | 08 |
| 10 | 8. marts 2017 | 8. marts 2017 | Batch 60 | 0 | 0 | N | marts | 0 | March | 08 |
| 10 | 8. marts 2017 | 8. marts 2017 | Batch 30 | 0 | 0 | N | marts | 0 | March | 08 |
| 10 | 8. marts 2017 | 8. marts 2017 | Batch 50 | 0 | 0 | N | marts | 0 | March | 08 |