Number of calculations exceeded

[Brad King]

I have a form with several tables. Each of these tables has a $ column with a
total at the bottom. When filling out this form. After entering several
values. The following error message pops up:

"A calculation in the form has not been completed. The number of
calculations used for a single action exceeded the maximum limit."

Is there really a limit imposed ? this happens after I fill about 14 or so
values.

 

[Brian Teutsch [MSFT]]

There really is a limit of 16, in order to prevent infinite recursion when
calculations and code are run. Have you used sum() on a repeating field?
This might cut down on the number of calcuations that happen when a a single
field is updated.

Brian

 

[Brad King]

I found the error in my form (I had my formula copied into another cell on
accident).. but I have a table .. not a repeating table. With 15 rows in it
... the last row calculates all the values in the 15 above it .

Does this mean if I add one or more row to be calculated. that I will
receive the same error ?

 

[Brian Teutsch [MSFT]]

I'm still not sure how you've set up your calcuations. fieldTotal = field1 +
field2 + ... field100 will work just fine. But if you have rules to set set
field1 = something, field2 = something... when fieldTotal changes, then yes,
you'll encounter this error.

 

[Nick]

Does this mean that a particular field is limited to 16 re-calculations on
one change event (the fieldTotal from below, as an example) or the form is
limited to 16 calculations?

How does summing a repeating field count towards the total?

Thanks,
Nick