691586_en-US

liliconcom

Column formula dependency cycle error

Hi all, 

 

Just wonder how we can do circular references in JSL.For example, I have a population qty and failure rate. But the failure rate for each year depends on the survive parts.

 

Year Original equipment   Failed    Survive

1        100                           1             99

2        99                             2             97   

3        97                             3             94

 

I know JMP doesn't allow a column to have a formula depends on the other formulated column. Is there a trick to work around for this case?

 

Thanks

Thanks

Automation and Scripting