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:
 
					
				
				
			
		
