Normal
0
false
false
false
EN-US
X-NONE
X-NONE
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
Hi Everyone,
I have a question.
I have an expense form that has two repeating tables. The first table is for Mileage only with
different columns and calculations. The
second table is for General Expenses, i.e. Meals, Lodging, Transportation, and Mileage.
My organization has some General Expenses that are
classified as Mileage for accounting purposes.
I have another question posted located at http://www.infopathdev.com/forums/t/27728.aspx that
asks how to summarize the General Expense amounts into a summary table by categories so
another department can process it for payroll purposes.
After that question is answered, I need to know how to add
the Total Mileage amount calculated from the Mileage repeating table into the summary
table by category where the category = Mileage.
To help make this more clear:
The Mileage table has Date, Begin Location, End Location,
Odometer readings, Miles and the amount based on the miles * the Federal Reimbursement
Rate for the date.
The General Expense Table has Date, Expense Description,
Category, and Cost.
Both tables have totals in the footers of the tables.
The Summary table has Category and Total Amount. I’d like to add the Total Amount from the
footer of the Mileage table to the Mileage Category from the General Expense
summary table and not in any other category.
For example:
My Total Mileage Amount = $100.00
My General Expense Categories are as follows:
Mileage = $50.00
Continuing Education = $35.00
Lodging = $750.00
Etc.
My Summary table should look like this:
Mileage = $150.00 ($100.00 from the Mileage Table and $50
from the General Expense by Category table
Continuing Education = $35.00
Lodging = $750.00
Etc.
How would I accomplish this?
Thanks so much.