Dear Sir,
I am using gINT V8i version software. we are doing Fence and borehole logs using this. Now I need to find the average for RQD and also this need to be displayed in the fence.
I manged to display the RQD values in the fence, but unable to find the average. So I request you to help us with the code to find the average for this.
Your reply early will be highly appreciated.
(The reference pics attached for your reference. Kindly check the attached file)
Hi Alaa,
You could use the AVG function. I assume you want an avg for each borehole and place it at the bottom of the log stick.
If you use a text vs depth entity you could place it at hole depth.
The text expression could be
<<Avg(<<Your Table Name.Your Field Name>>,,0)>>
The Depth expression could be
<<POINT.HoleDepth>>
I would top align with a small vertical offset say -0.05 or -2 if your report units are in mm
The fence report design tutorial is a great resource for making design changes to your fence
Fence Report Design, Surfaces and Modeling Product(s): gINT Logs, gINT Professional, gINT Professional Plus Version(s): N\A Environment: N\A Area: Report-Fence Subarea: N\A … Last edited 10 months ago in OpenGround | gINT | Keynetix > gINT | Keynetix Wiki
Thank You Johnson. Appreciated your response. I will try with the AVG SQL Code you have provided.
I will try this in fence, then it will be easy for the calculation and also we can review in a single view.