Formula question

[Bryan]

I have a form for employees mileage logs.
I can sum the total miles but I need to sum each entry. See -
www.bojik.com/formula.pdf for a sample of the form.

 

[S.Y.M. Wong-A-Ton]

Hi,

It's not clear to me what your current challenge is. You could use
expression boxes to do the summing across rows as well as columns in a
repeating table.

Regards,
S.Y.M. Wong-A-Ton

 

[Bryan]

S.Y.M.,

I am not trying to sum accross the rows. I need to get the difference of
"startOd and EndOd" on each row so I need to subtract not add. I will then
sum the "Total Miles" at the bottom with a sum formula.

Also is there a way to do a sumif statement in infopath? Once I get the
above problem worked out I need to sum the "Total Miles" column by each Job #.

Bryan

 

[S.Y.M. Wong-A-Ton]

Hi,

You can also use an expression box to subtract. Try converting the total
miles field to an expression box, then enter the following formula: StartOd -
EndOd
where StartOd and EndOd are the fields in your table. Also make sure that
StartOd and EndOd are of a numeric type (whole number or decimal) and not
text. You can change this through the properties dialog box of the
corresponding fields in your form's data source.

I don't believe you can do a sumif without using custom code. Have a look at
the Expense Report sample form that comes with InfoPath. It contains code to
do additions in a repeating table.

Hope this helps.

Regards,
S.Y.M. Wong-A-Ton