Hello - I'm having a cycle detected in one of my tables, and I can't seem to find documentation on cycles. Maybe its there, and google and JMP's help index are failing me, but I'm pretty confused what the cycle report means. I'm currently getting the following report:
Cycle detected for data column: Best concentration source
1. Calculated concentration
2. Best concentration value
0. Best concentration source
2. ::RowColumn::
2. Solution name
2. ::GlobalVariableColumn::
2. atomic weight (g/mol)[Element]
2. Salt Identity
2. Tube
2. Tube + Metal Solution A
2. Liquid A
2. Calculation method
2. ::TableVariableColumn::
Cycle detected for data column: Best concentration source
1. Calculated concentration
2. Best concentration value
0. Best concentration source
3. Guessed concentration
2. ::RowColumn::
2. Solution name
2. ::TableVariableColumn::
2. ::GlobalVariableColumn::
2. atomic weight (g/mol)[Element]
2. Tube + Metal Solution A
2. Volumetric Flask
2. Tube
2. Liquid A
2. Calculation method
2. Salt Identity
1. ICP concentration
I guess I'm confused what the numbers mean, why different indents happen, etc.
P.S.
I'm assuming its not necessary to answer the question above, but here is the code that's the issue if that helps. It's part of a larger series of nested if statments in column :Calculated concentration.
((:"Tube + Metal Solution A"n - :Tube) / 1000) * (row_idx = Loc( :Solution name << Get Values, :Liquid A ) ; If( N Items( row_idx ) < 1,
.,
Lag( :Best concentration value, Row() - row_idx[1] )
))
while :Best concentration source has as a formula
If( Is Missing( :ICP concentration ),
If( Is Missing( :Calculated concentration ),
If( Is Missing( :Guessed concentration ),
.,
"Guessed concentration"
),
"Calculated concentration"
),
"ICP concentration"
)
Thanks!
Edward Hamer Chandler, Jr.