Total Costs derived from 2 other Repeating Tables and Quantities

FlameKurosei — Wed, 16 Aug 2017 18:18:01 GMT

Hello everyone,

I'm having trouble with a particular part on the IP filler form I'm working on, and after some searching on this forum, I am still quite confused.

The form I'm working on, to put it simply, is a cost estimate sheet which has 2 pages to calculate costs, and 1 page to total them up. The quantities on each "page" is the same, and there is a default value so after some clicking to add rows, the same quantities show up per page. However, one of the calculating cost pages is not displaying any amount, even after I establish some rules.

In order to solve this problem, I have created a very basic mock-up of the form for your perusal. In this mock up, "page 2" works (aka the yellow table), but "page 3" does not (aka the blue table).

Here's a preview of what I mean for more clarification (with both not filled and filled in screenshot):

In worded detail:

On Page 1, the customer's desired quantities are put in, and these carry throughout the rest of the form.

On Pages 2 and 3, the quantities are used to calculate the particular page's cost. (Essentially, think of the quantity as a batch of individual pieces for a certain price, like buying a box of 100 candies for a $10.00. A batch with more individual pieces is generally cheaper in cost.) For the preview's numbers, for example, Page 3's totals should be [Qty = 100, Material Total = $1200.00], and [Qty = 200, Material Total = $1000.00].

(Note on page 3 I did not include a counter for the step field for the sake of simplicity, but it is in the main form.)

Finally, the "Overall Total Cost" on Page 1 should be a sum of the respective quantity. In respect to the preview, this should be [Qty = 100, Overall Total Cost = $2200.00], and [Qty = 200, Overall Total Cost = $1900.00].

I am new to InfoPath, so please suggest solutions that are based on rules/default values/etc. if you can. Let me know if there is anything confusing I should clarify.

Thank you very much,

~Flame

Newbie Questions

Total Costs derived from 2 other Repeating Tables and Quantities