SP Ent 2010, Infopath 2010. I have an HR site that I have created a "Employee Record" infopath library. In the infopath form I have a section that is Employee Benefits. It is several repeating tables, one each for each type of benefit,
Health, Dental, Vision Insurance and so on. There is a field in each table that is "Monthly Premium". I'm using repeating tables so my client can track changes in benefits. I want to total the Monthly Premium field but of course when I add
more than one record to the repeating tables it's totaling all records. Is there a way to only total the last record in multiple repeating tables?