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 :
| Quantity |
Unit Price |
Total Price |
| |
|
|
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:
|
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 :
|
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.