Hi everyone. I really need your guys help. I am trying to make an invoice form using infopath 2010. I have a column called "Taxable" and have a drop down control saying "Yes" and "No" to show if the item is able to be taxed. I set yes to equal true and no=false (boolean).
I have another column that shows the "Net Total" for that item which multiples the quanity and item cost.
Heres my problem:
I have a column called "Taxable Total" which I want to show the sum of the "Net Total" multipled by the current tax rate ONLY if the Taxable column is marked yes for that item.
I am using a repeating table.
Please help, thanks