I have a repeating table in a form that has 2 date pickers, and a field displaying a date difference that I got from this wonderful blog http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/ (shows how to calculate the difference between days excluding work and holidays).
In the footer of the repeating table, I need to sum the total days from the date difference, so I used a default value of sum(totalworkdays).
When previewing, this only works HALF the time. The other half I get the error "A calculation in the form has not been completed. The number of calculations used for a single action exceeded the maximum limit.". Of course, I have the "refresh value when formula is recalculated" option checked, because I NEED it to be recalculated.
I have attached the form. Please let me know if you see any obvious problems.
It's wierd that it only happens HALF the time. When I uncheck the refresh value box, it works no problem. It just doesn't refresh. ; )