I have a table that has a column (Samp Pt) which lists the equipment name as Equip_n where n is 1 through 9.
The Column "Date / Time" is the date and time.
The data is sorted by Equip_n and then Date / Time.
I want to create a value called Run which is the Run number for each piece of Equipment. The Run is the Equipment number-Run, e.g. 1-1. A new Run is defined when the difference between successive rows of Date/Time is greater than 190,000 seconds.
I tried using two local variables to keep track of the numerical value of the "n". It creates the first Run Value for each Equipment correctly ("1-1, "2-1", etc.) but when the successive rows are >190000 seconds apart, I get "1-.", "2-."). I'm pretty sure that I'm not using the local variables correctly. What am I doing wrong? Thank you.