I've hit a wall with my form design. I#%92m trying to setup a repeating table where a field takes the value from it's preceding field and reduces it by a percentage. This calculation needs to be active through the lifespan of the form, so if i change the value in the first row, all following rows should update as well.
However, once i hit 15 rows, i reach the calculation recursion limit of InfoPath and the fields no longer update past that point during a recalculation.
My data structure looks similar to the following:
MyRows
>>>MyRow (Repeating)
>>>>>>NumberField
>>>>>>ReductionPercentage
The calculation im using is the following which is assigned to "NumberField":
round(../preceding-sibling::my:MyRow[1]/my:NumberField * (1 - (../my:ReductionPercentage div 100)))
Is there any know workarounds i may use here? Or is there a way to increase the recursion limit in InfoPath?