Hello,
In one of my test boring templates, I want to put a flag when the BOTTOM OF EXPLORATION in the STRATIGRAPHY table does not equal the <<(POINT.HoleDepth)>>.
I can think of a way to approach it, although I don't know if it is possible:
If I could somehow identify the bottom-most entry in the <<(STRATIGRAPHY.Bottom)>> field, I could make a simple comparison with the HoleDepth and if it doesn't match, flag it in the margin of the log.
Is there a way to identify the last entry?
If not, is there another way to think of this?
Thanks for any insight....
Terry
Hi Terry,
You could try using the <<Max()>> function. For example, with a Text Entity you could do something similar to the following for the Text Expression:
<<IIf(_ <<Max(<<STRATIGRAPHY.Bottom>>)>> <> <<POINT.HoleDepth>>,_ "Bottom of exploration in the Stratigraphy table does not equal the Hole Depth in the Point Table."_)>>