Calculation rules for repeating table - InfoPath Dev
in

InfoPath Dev

Calculation rules for repeating table

Last post 03-23-2011 09:27 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-16-2011 09:07 PM

    Calculation rules for repeating table

    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.

  • 03-23-2011 09:27 AM In reply to

    Re: Calculation rules for repeating table

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

    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.