Calculated field

Hi;

I have created an expense report template, that has a
column of totals. Each total is a form field, marked as
a "Number" and "Calculate on Exit". At the bottom of the
column, I have a subtotal, which works fine. The next
field is a form field which is also marked as "Number"
and "Calculate on Exit" where users can put an amount
advanced to them.

The last field is the problem, it is a form field, marked
as "Calculation", where I have =text25-text26, so the
advance is subtracted from the subtotal, which should give
a Grand total.

If I enter "35.00" in one of the total fields, it will
put "3535.00), so it doubles whatever number I enter. Can
you help?

It looks like this;

Airfa 35.00
Hotel: 125.00

Subtotal: 145.00
Less Adv: 50.00

Total: 3535.00

Thanks!

In a formfield calculation, you cannot use as an input to the calculation
another formfield that is itself the result of a calculation.

To get the total, you will have to use

= airfare + hotel - advance

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Julie" wrote in message
...
Hi;

I have created an expense report template, that has a
column of totals. Each total is a form field, marked as
a "Number" and "Calculate on Exit". At the bottom of the
column, I have a subtotal, which works fine. The next
field is a form field which is also marked as "Number"
and "Calculate on Exit" where users can put an amount
advanced to them.

The last field is the problem, it is a form field, marked
as "Calculation", where I have =text25-text26, so the
advance is subtracted from the subtotal, which should give
a Grand total.

If I enter "35.00" in one of the total fields, it will
put "3535.00), so it doubles whatever number I enter. Can
you help?

It looks like this;

Airfa 35.00
Hotel: 125.00

Subtotal: 145.00
Less Adv: 50.00

Total: 3535.00

Thanks!

Thank you so much

-----Original Message-----
In a formfield calculation, you cannot use as an input to
the calculation
another formfield that is itself the result of a
calculation.

To get the total, you will have to use

= airfare + hotel - advance

--
Please post any further questions or followup to the
newsgroups for the
benefit of others who may be interested. Unsolicited
questions forwarded
directly to me will only be answered on a paid consulting
basis.

Hope this helps
Doug Robbins - Word MVP
"Julie" wrote in
message
...
Hi;

I have created an expense report template, that has a
column of totals. Each total is a form field, marked as
a "Number" and "Calculate on Exit". At the bottom of
the
column, I have a subtotal, which works fine. The next
field is a form field which is also marked as "Number"
and "Calculate on Exit" where users can put an amount
advanced to them.

The last field is the problem, it is a form field,
marked
as "Calculation", where I have =text25-text26, so the
advance is subtracted from the subtotal, which should
give
a Grand total.

If I enter "35.00" in one of the total fields, it will
put "3535.00), so it doubles whatever number I enter.
Can
you help?

It looks like this;

Airfa 35.00
Hotel: 125.00

Subtotal: 145.00
Less Adv: 50.00

Total: 3535.00

Thanks!

.