topic Re: Using In Column Data to Calculate a New Column in Discussions

Using In Column Data to Calculate a New Column

Jacovz — Sat, 10 Jun 2023 23:57:18 GMT

I am trying to use the data in columns to calculate in a new column.

The columns with data will be ID, From(Depth),and RL

The problem is I want to calculate a "depth" below a specific point (RL).

How I see the formula is if ID=ID and From = 0 then use the RL at From=0 and subtract the RL at the next From and repeat till the a new ID

txnelson — Fri, 25 Nov 2022 02:18:24 GMT

The description of the data table attached to your entry is different from what is in the attached data table. The attached data table contains

mFrom

mTo

RL_MGA20

What you describe is that your data table has

"The columns with data will be ID, From(Depth),and RL"

I do not understand what you are asking for

Jacovz — Fri, 25 Nov 2022 03:01:33 GMT

Hi Jim,

What I am trying to achieve is to create a depth from a common plane / point which is the collar of a drill hole.

If ID=ID (from the same hole) and From = 0 then RL(value where From = 0) - RL .

I have update the file to better reflect the question, also i added a column Expected_outcome to show what i am trying to achieve.

ID is the drill hole name

From is the depth from the collar at surface

RL is the height of the point with respect to sea level.

Depth_From_0 would be the depth below the surface where From=0 and the corresponding RL

txnelson — Fri, 25 Nov 2022 03:39:08 GMT

Here is the formula I used to get the below results

If( :From == 0, hold = :RL );
hold - :RL;

Jacovz — Fri, 25 Nov 2022 03:44:45 GMT

Hi Jim,

Thank you for the solution.