Forum Discussion
Solved
First Production Date across Category
I am trying to find the date that first production of any kind (green>0 or red>0) occurred for an item and to assign that date across the category item #. Below is a sample set of my data and a colum...
How would this same formula work if the two columns that needed to be <> 0 came from two different tables? For example I still need the first date of production between red or green of an item but those columns are in the two tables {see below}. The tables are already joined by an index in the model
| TABLE 1 | |||
| Date | Item | Green | |
| 1/1/2023 | 1 | 7 | |
| 1/2/2023 | 1 | 545 | |
| 1/3/2023 | 1 | 68 | |
| 1/1/2023 | 2 | 21 | |
| 1/2/2023 | 2 | 547 | |
| 1/3/2023 | 2 | 85 | |
| 1/1/2023 | 3 | 312 | |
| 1/2/2023 | 3 | 0 | |
| 1/3/2023 | 3 | 4 | |
| TABLE 2 | |||
| Date | Item | Red | |
| 1/1/2023 | 1 | 5 | |
| 1/2/2023 | 1 | 64 | |
| 1/3/2023 | 1 | 12 | |
| 1/1/2023 | 2 | 78 | |
| 1/2/2023 | 2 | 92 | |
| 1/3/2023 | 2 | 41 | |
| 1/1/2023 | 3 | 2 | |
| 1/2/2023 | 3 | 7 | |
| 1/3/2023 | 3 | 7 |