K
>>KY
Hello,
I am learing how to use infopath form 2007, I am stumped on the math formulas for the form that I am creating. I have 8 repeating tables that includes a dropdown list of different codes in the first column, second is a name box and the third is to include dollar amt. My question is can the repeating tables look for the subtotals in its own box? The blue group is the repeating tables with 3 columns labeled in pink.
The colors are color coordinated to show you what is totaled. it is straight forward adding in each section. Can this all be done separately since I have up to 8 repeating tables? Please help and thank you for your time.
BUILDING SQUARE FOOTAGE:
Building Section 1
csi code Sub-Contractor Name Bid Amount
SITE
02-260 CLEARING AND GRUBING
02-300 EARTHWORK
CONCRETE
03-050 FOUNDATION AND SLAB
03-050 SIDEWALKS BUILDING
MASONRY
04-210 CMU
04-400 CAST STONE
SUB-TOTAL BUILDING -
General Conditions Section 2
csi code Bid Amount
01-140 PERMITS
01-150 TAPS AND FEES
SUB-TOTAL - GENERAL CONDITIONS -
Totals Section 3
TOTAL PROJECT (sum of the subtotal building)-
TOTAL GEN COND(sum of the subtotal Gen Conditions) -
SUB-TOTAL - Total of both project and gen cond -
CENTRAL EXPENSE / INSURANCE -
FEE
SALES TAX
PROJECT TOTAL $- Sum of ( SubTotal, CENTRAL EXPENSE / INSURANCE , FEE , SALES TAX )
Square Foot Cost - (BUILDING SQUARE FOOTAGE (at top) / PROJECT TOTAL)
I am learing how to use infopath form 2007, I am stumped on the math formulas for the form that I am creating. I have 8 repeating tables that includes a dropdown list of different codes in the first column, second is a name box and the third is to include dollar amt. My question is can the repeating tables look for the subtotals in its own box? The blue group is the repeating tables with 3 columns labeled in pink.
The colors are color coordinated to show you what is totaled. it is straight forward adding in each section. Can this all be done separately since I have up to 8 repeating tables? Please help and thank you for your time.
BUILDING SQUARE FOOTAGE:
Building Section 1
csi code Sub-Contractor Name Bid Amount
SITE
02-260 CLEARING AND GRUBING
02-300 EARTHWORK
CONCRETE
03-050 FOUNDATION AND SLAB
03-050 SIDEWALKS BUILDING
MASONRY
04-210 CMU
04-400 CAST STONE
SUB-TOTAL BUILDING -
General Conditions Section 2
csi code Bid Amount
01-140 PERMITS
01-150 TAPS AND FEES
SUB-TOTAL - GENERAL CONDITIONS -
Totals Section 3
TOTAL PROJECT (sum of the subtotal building)-
TOTAL GEN COND(sum of the subtotal Gen Conditions) -
SUB-TOTAL - Total of both project and gen cond -
CENTRAL EXPENSE / INSURANCE -
FEE
SALES TAX
PROJECT TOTAL $- Sum of ( SubTotal, CENTRAL EXPENSE / INSURANCE , FEE , SALES TAX )
Square Foot Cost - (BUILDING SQUARE FOOTAGE (at top) / PROJECT TOTAL)