Hi All,

I have a situation currently which has totally stumped me.

I have a requirement to generate a report out of Salesforce.com and then merge it in the word format. In my report I am getting an extract of all the opportunities created in this year and then the revenue associated to those opportunities.

My word format should include the the total count of opportunities and then sum total of the revenue. For the total number of Opportunities I was able to do that by using the RowCount in merge field. However I am not able to do the sum of the revenue. I have tried the below syntax but somehow it always gives the Syntax error

{=SUM({MERGEFIELD Opportunity_Revenue})}.

I have tried this by using Ctrl-F9 for inserting the curly brackets and then typing the field manually or even by inserting the field by using Quick parts and then inserting the merge field. However word always says syntax error after doing F9.

I wanted to understand if that is even possible at all? or if there is anything wrong in my syntax.