> 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.,
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
> Hi,
>
[quoted text clipped - 8 lines]
> > 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 - 06 Jan 2006 19:39 GMT
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
> S.Y.M.,
>
[quoted text clipped - 19 lines]
> > > 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.