Forum Discussion
Need Help with Summing Values
I am trying to add up my cycle time and review time to give a column for lead time. the Cycle time is summing based on the count an Analysis (Tests) which is correct. however, the review time is doin...
Anonymous
pls see the attachment below. Hope it's helpful.
still have a question. why the date for expected output is 2020/1/15 and 2020/1/16?
Anonymous
sry, still not clear about this. Could you pls provide some sample data, not the screenshot and also provide the expected output based on your sample data?
Sample Data:
| Date | Testing Cycle Time | Testing Lead Time | Testing Review Time | Last Analysis | |
| 4/14/2020 | 20 | 60 | 45 | AZBR_ID_E_EP_N | |
| 4/14/2020 | 20 | 60 | 45 | AZBR_ID_E_EP_N | |
| 4/14/2020 | 20 | 60 | 45 | AZBR_ID_E_EP_N | |
| 4/14/2020 | 20 | 60 | 45 | AZBR_ID_E_EP_N | |
| 4/14/2020 | 20 | 60 | 45 | AZBR_ID_E_EP_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N | |
| 8/4/2020 | 10 | 90 | 30 | AZBR_ID_A_EP_QC9522_N |
Current Results:
| Year | Month | Day | Count of Product2 | Testing Cycle Time | Testing Lead Time | Testing Review Time | Total Time | Last Analysis |
| 2020 | April | 14 | 5 | 100 | 300 | 225 | 625 | AZBR_ID_E_EP_N |
| 2020 | August | 4 | 10 | 100 | 900 | 300 | 1300 | AZBR_ID_A_EP_QC9522_N |
Expected Result:
| Year | Month | Day | Count of Product2 | Testing Cycle Time | Testing Lead Time | Testing Review Time | Total Time | Last Analysis |
| 2020 | January | 15 | 5 | 100 | 60 | 45 | 205 | AZBR_ID_E_EP_N |
| 2020 | January | 16 | 10 | 100 | 90 | 30 | 220 | AZBR_ID_A_EP_QC9522_N |
Total Time = SUM(Testing Cycle Time + Testing Lead Time + Testing Review Time)
Let me know if this helps!