Forum Discussion
Problem with calculate value in different table
In this table (LINEE) i have my product lines
|
In this table (DURF) there are phases duration (some machines have two or three phases)
|
In this table (PDPMA00F) i have machines and i want sum "start date" with a sum of all phase durations to have a potential finish date.
| Stabilimento | Scheda_Tecnica | Custumer_number | Order | Data_consegna_cliente | start_date | Serial | qta | Linea | Tipo_linea |
| 01 | 940002.099 | E00010 | 21005610 | 24/11/2021 | 08/11/2021 | SPXT-01303 | 1 | 800 | S07 |
| 01 | 940006.060 | E00010 | 21004139 | 05/11/2021 | 27/10/2021 | SPHG-00271 | 1 | 900 | S19 |
| 01 | 930014.373 | E00010 | 21006669 | 14/02/2022 | 21/12/2021 | SP12-02116 | 1 | 1201 | S31 |
| 01 | 960006.605 | E00010 | 21006669 | 14/02/2022 | 27/01/2022 | LA50-03286 | 1 | L4 | L27 |
| 01 | 960001.295 | E00010 | 21006669 | 14/02/2022 | 19/01/2022 | LA51-02831 | 1 | L5 | L20 |
4 Replies
Can you please post a depiction of the expected output?
Hi,
In DURF table i have the same element with different value, i want to sul those value to have how many day i need to make a new machine and then i want to sum that value with start date to see the end date.
Sorry, I'm finding it hard to follow. Can you recreate the outpu in excel and post the screenshot please?
Hi, thx for your patience.
Here we are: i need to cumulate values in DURF TABLE group by TIPO_LINEA and then i want to use this result in PDPMA TABLE. i need to sum this new value with DATA_MESSA_MONTAGGIO to add the days that will be necessary to complet out product.
If you want you can download dataset here https://www.dropbox.com/s/xmcopr0ln3k1e39/Calendario%20consegne.pbix?dl=0
Sorry for my bad english 😞
