Forum Discussion
Calculate completed operation and date difference
Hi, I'm trying to calculate Completed? column based on serial #s, operations 10-30 = completed operation based on serial #. Then calculate the date difference between completed serials (10 and 3...
Greg_Deckler
Community Champion
Community ChampionAnonymous Hmm, hang on, what are the actual values for 10, 20 and 30 Operation #'s? Also, does a serial # need to have all three Operation # values to be present before it is considered completed or is a single "30" value sufficient?
Here's the extended data and desired output: serial # 4 has no Operation 10 so it's not complete.
Hope someone can help me. Thank you.
| Serial # | Operation # | Date completed | Completed? Op # 10-30 - Desired output |
| 1 | 10 | 1/2/2022 | Y |
| 1 | 20 | 1/3/2022 | Y |
| 1 | 30 | 1/5/2022 | Y |
| 2 | 10 | 1/8/2022 | Y |
| 2 | 20 | 1/10/2022 | Y |
| 2 | 25 | 1/12/2022 | Y |
| 2 | 30 | 1/14/2022 | Y |
| 3 | 10 | 1/5/2022 | N |
| 3 | 20 | 1/9/2022 | N |
| 3 | 25 | 1/12/2022 | N |
| 4 | 20 | 1/10/2022 | N |
| 4 | 25 | 1/11/2022 | N |
| 4 | 30 | 1/12/2022 | N |