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.
|