AnsweredAssumed Answered

Search for the next record

Question asked by DranLang on Oct 17, 2013
Latest reply on Oct 22, 2013 by DranLang

Title

Search for the next record

Post

     I'm working on a filter of some sort.  I currently stuck on the search process so I could subtract a value of a field with another value.

     In my table I have Id#, B_Depth, H_Depth, Start, End, and Meters.  If Start = true it will look for the value of H_Depth where the next value of End = True, then subtract it with the value of H_Depth in the current record number.

     Below is how my formula looks like but it's giving me  "?" instead of the actual difference of the two values.

     Let(R=Get(RecordNumber);
     If(R> 0;

     If(Drilling_Start = "True";GetNthRecord(Hole_Depth; Drilling End="True") - Hole_Depth; 0)))

     I'm sure it's my GetNthRecord that has an error and I don't know how to make it work.

Outcomes