Hi @cinnabar,
You have created an infinite loop between the equation and the dependencies defined in the calculated field:
The equation associated to the calculated field is:
fieldname6+(fieldname8*fieldname2)+(15000)+fieldname5+fieldname14+fieldname15+fieldname16+(fieldname5*75)+(fieldname14*90)+(fieldname15*70)+(fieldname16*30)
and the dependencies:
If the result >= 74000, then the fields: “fieldname14”, “fieldname5”, “fieldname15”, and “fieldname16” are available.
But if the result <= 116000, then the fields: “fieldname14”, “fieldname5”, “fieldname15”, and “fieldname16” are available.
So, if the result is >= 74000 the fields: “fieldname14”, “fieldname5”, “fieldname15”, and “fieldname16” are available and the equation should be reevaluated, because there are new fields to take into account, but as the equation was reevaluated, the dependencies should be checked again because the result of the equation has varied, and so on. If the fields that are used in the equation are modified with the dependencies you generate an infinite loop.
Other type of infinite loop can be generated indirectly, for example, if the field A uses the field B in its equation, the field B uses the field C, and the field C uses the field A, closing the loop.
Best regards.
Thank you for your reply, still a bit confused as to how I am to fix the problem. Can you please provide instructions to correct the error.
Sorry, forgot to add that the calculations worked fine up untill the last update.
Sorry, I figured it out. Thank you for your prompt response.
