Hi! I have a database style data table that stores data from a bunch of process steps. Each row represents a sample from a given process step, and in that row, there is a reference to the parent sample. The parent sample is from the same material, but at the previous process step. I am mostly interacting with this database table through a jmpapp, so scripting is an acceptable way to manipulate the data.
Within this table, I want to calculate some parameters about each sample, including how that sample has changed compared to the parent sample. Some of those parameters might be calculated as:
measured data from child * measured data from parent.
Other parameters might be calculated as follows (where calculated value from parent would be similar to the equation above):
measured data from child * calculated value from parent
I have a currently working solution for this, but it is very slow, and requires a lot of calls to "Rerun Formulas".
So, before I describe my currently solution, I would like to get some recommendations for the best ways to accomplish this. Maybe I am going about the data structure the wrong way! If possible, it would be amazing if I could keep the calculations within this table.
Below is an image showing the current structure of the data and how it needs to be cascaded from parent to child in order to do all of the proper math.
Thanks for your help!
