Re: Calculation rules for repeating table

Hilary Stoupa — Wed, 23 Mar 2011 16:27:26 GMT

Are all the controls in your repeating table bound correctly to fields in the main data source?

Calculation rules for repeating table

Petrisha — Thu, 17 Mar 2011 04:07:44 GMT

hai...

Currently im developing quatation Form using Infopath 2007. There is a repeing table which will calculate amount of the unit price. the design of the form is :

TopMargin

Quantity	Unit Price	Total Price

Our Price	Total	Margin

The calculationwill be like this:

a) TopMargin is in percentage

b) Unit Price = (Our Price *TopMargin)+ Our Price

c) Total Price = Quantity * Unit Price

d) Margin = Total Price - Total

Unit Price, Total, Total Price, and Margin will be automatically calculate once key in the TopMargin and Our Price. "Our Price" will be key in first. But sometimes "Unit Price" will be key in first and leave the "Our Price" with blank.

* I already set the rules in repeating table.Im facing problem when reopen the submited form. Once i fill in values in repeating table and submit, its working correctly. But when i reopen again the submitted form from sharepoint library, values in repeating table row which i key in "Unit Price" first and leave the "Our Price" with blank looks empty. but the table should be like this:

Margin:

15%

Quantity	Unit Price	Total Price	Our Price	Total	Margin
1	1748	1748	1520	1520	228
1	800	800	0.00	0.00	800

But when reopen the form, the repeating table looks like :

Margin:

15%

Quantity	Unit Price	Total Price	Our Price	Total	Margin
1	1748	1748	1520	1520	228
1	0.00	0.00	0.00	0.00	0.00

Anyone can help to solve this problem? any other rules or idea to can be applicable for this problem?

Thanks in Advance.

Browser Forms

Re: Calculation rules for repeating table

Calculation rules for repeating table