Hey all,
I have a form with a repeating table that I'm using to build invoices with and I've ran into an issue. For example, I have an "equipment" repeating table that is fed from a "Rent Equipment" list and shows how much we charge for a piece of equipment. Each day the piece of equipment is used, a new line item is entered in the Rent Equipment. When the invoice is ready to be made, InfoPath brings all of the line items together and is supposed to aggregate them. My problem arises when there is a date break with a piece of equipment.
Let's say Billy is renting a machine from 7/1/15 to 7/10/15 but on 7/4/15 he didn't use it. How would I get InfoPath to show the date break as well as calculate it? (The clients like to see the days rented.) So far I have a conditional formatting rule that will highlight the duplicate in green and will not be shown on the invoice but I can't figure out how to calculate the total with day breaks or show the day breaks.
