View Single Post
 
Old 06-11-2013, 02:55 PM
kawirider88 kawirider88 is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Jun 2013
Posts: 2
kawirider88 is on a distinguished road
Default SUM a single mergefield

Hello All, this is my first time to the forums and I am also fairly new to mail merge. So first off thanks for any help!

I am running mail merge to create a Quote from Microsoft Dynamics CRM 2011. In the Quote there are a series of products each one is different and ranges in the number of products that might be requested. The merge field for example might be {Mergefield Quote_Product_Cost} and the output would list all the product costs for each product requested. If possible I would like to be able to add up all the product costs.

I have tried {=SUM({Mergefield Quote_Product_cost})} but I get a syntax error. Could someone please tell me what I'm doing wrong or if this is even possible? So far the only thing I have seen is how to sum up two different mail merge fields but in my case the one mergefield returns several values.

Thanks so much for the help.
Reply With Quote