Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2004

Tip: Looking for answers? Try searching our database.

Calculated field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Julie - 11 May 2004 19:11 GMT
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;

Airfare:    35.00
Hotel:     125.00

Subtotal:  145.00
Less Adv:   50.00

Total:     3535.00

Thanks!
Doug Robbins - Word MVP - 12 May 2004 05:46 GMT
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

Signature

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

> Hi;
>
[quoted text clipped - 26 lines]
>
> Thanks!
Julie - 12 May 2004 06:29 GMT
Thank you so much

>-----Original Message-----
>In a formfield calculation, you cannot use as an input to the calculation
[quoted text clipped - 36 lines]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.