Quote:
Originally Posted by Shelley Lou
I still can't get the percentage figures to reflect the same as those in the spreadsheet for columns F and M, most just display as 0.00%.
|
Your first table should end up with a field coded as:
{=«REINVEST»*100 \# 0.00%}
Similarly, for your second table, you should end up with a field coded as:
{=«DRP_ALLOCATION_»*100 \# 0.00%}
It works for me with the files attached to your first post.
If you don't want the calculation field code to remain in the output document, wrap the above field codes in QUOTE fields, thus:
{QUOTE{=«REINVEST»*100 \# 0.00%}}
{QUOTE{=«DRP_ALLOCATION_»*100 \# 0.00%}}
What I did notice is that completing the mailmerge causes a 'field calculation error' to be reported for every record. That is caused by the DOCPROPERTY field in the footer and has nothing to do with the above field coding.