Thread: [Solved] Bookmarking Formula Results
View Single Post
 
Old 11-09-2012, 01:13 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Because you're using DollaText, the field output is text and you'll not be able to use the bookmarked result as the input to another formula. However, a change to the field code will allow you to overcome that. Simplify the calculation and embed it in its own field, thus:
{={=settlefee*0.75-costs \# 0.00} \*DollarText \*Upper }
and bookmark the portion in red. Note that the braces (ie {}) ecompassing the red portion are field braces, which you create via Ctrl-F9.

Alternatively, create a SET field to hold the calculation and refer to the SET field's bookmark for both purposes:
{SET Result {=settlefee*0.75-costs \# 0.00}}
{REF Result \*DollarText \*Upper} - for the existing output
{=Result-Support \*DollarText \*Upper} - for the additional output
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote