InfoPath Dev

correction: if Sum(Line_charge)>InvoiceAmount add to LastRow(Line_charge) $0.01

Aruna, thank you for your reply. But, I am looking more for a solution such as: Sum(Line_charge) if the line_charge>InvoiceAmount add to LastRow(Line_charge) $0.01 Thanks.

FORM FIELDS: InvoiceAmount: (Example-)$5.29 Repeating table fields: Department (drop-down): (Example-marketing) Line charge (read-only) : (InvoiceAmount*percentage*0.01) Percentage (integer): (Example-50) SCENARIO: The invoice amount needs to be charged to the different departments. The accounting clerk enters the percentage, and the line charge ...