Hello,
I am working in InfoPath 2003 and would like to sum data taken from a repeating table. However, this sum needs to be based on the value of a second field.
For example - the table has a column for Amount and a column for Credit/Debit. If the Amount is < 0, the value in the Credit/Debit column is set at C. If the Amount is >/= 0, the value in the Credit/Debit column is set at D.
My goal is to have a field labeled Credit equal the sum of Amount when Credit/Debit = C and a field labeled Debit equal the sum of Amount when Credit/Debit = D.
I set the following rule from the Credit/Debit field: If Credit/Debit = C then set the field Credit to equal the sum of Amount.
However, the Credit field only shows that last value of Amount when Credit/Debit = C.
How do I show the sum of Amount for each C and D?
Thank you,
Tracie