How to use the result from the last row as input for the next row

[steakdeprived]

Hi all,

I am trying to create a Bayesian inference app that updates the probability of a hypothesis based on new evidence. The calculation relies on the result of the calculation from the previous row. Here NVC stands for New Virtual Column. However, when I change the code for NVC_P(H) from

IF([NVC_ENumber]=1, 0.5, 0)

to

IF([NVC_ENumber]=1, 0.5, [NVC_Prev_P(H|E)])

it hangs up and times out. Here is a sketch of the "circular" reference that is causing the problem. What is the best way to do this type of thing?

Thanks,

Ryan