The following table shows the number of products produced by a manufacturing plant on a daily basis.
DATE | UNITS PRODUCED |
01/01/2019 | 0 |
02/01/2019 | 0 |
03/01/2019 | 0 |
04/01/2019 | 0 |
05/01/2019 | 0 |
06/01/2019 | 5 |
07/01/2019 | 7 |
08/01/2019 | 4 |
09/01/2019 | 8 |
10/01/2019 | 0 |
11/01/2019 | 0 |
12/01/2019 | 5 |
13/01/2019 | 9 |
UNITS PRODUCED rows 1 -5 contain 0s. This is because plant operations don't commence until 06/01/2019. 0s that occur between 10/01/2019 and 11/01/2019 occurred during operational days but no units were produced.
I'd like to delete (or mark as 'null') Rows 1-5 from the table because I'm only concerned about production after the plant has commenced operations. The condition I'm looking for would find the first row in UNITS PRODUCED with a value greater than '0' and delete (or mark as 'null) all rows prior to this row (i.e. rows 1-5 in the example table).
Do I need to use the Multi-Row Formula tool?
Any help please,
Paul
Solved! Go to Solution.
Hi @CGlace you can indeed do this with a multi-row formula tool. If you set it up like this, then you get what you want: