Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-30-2019, 11:17 AM
shawn.low@cox.net shawn.low@cox.net is offline Simple Calculation with a Merge Field Windows 10 Simple Calculation with a Merge Field Office 2016
Novice
Simple Calculation with a Merge Field
 
Join Date: May 2019
Location: Aliso Viejo, CA.
Posts: 24
shawn.low@cox.net is on a distinguished road
Default Working Now

Through trial and error, I managed to get this working correctly.


The formula that worked looks like this:


{ = {MERGEFIELD TableStart:YourCongaQuery \*MERGEFORMAT}{MERGEFIELD Your_Merge_Field \* MERGEFORMAT}{TableEnd:YourCongaQuery \*MERGEFORMAT} - 1 \# "0" \*MERGEFORMAT}


For those "Not" using Conga Composer to generate your document, simply take out the two (2) Merge Fields "TableStart" & "TableEnd". The formula would look like this:


{ = {MERGEFIELD Your_Merge_Field \*MERGEFORMAT} -1 \# "0" *MERGEFORMAT}


Thanks
Shawn
Reply With Quote
 

Tags
math, merge field



Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple Calculation with a Merge Field How to prevent the auto-calculation of the '% Complete' field in MS Project Professional 2013? VivekG1 Project 1 02-06-2015 05:33 AM
Simple Calculation with a Merge Field Trying to round up a field based on a calculation but getting error messages bakerrl Excel 19 10-14-2014 05:44 AM
Simple Calculation with a Merge Field Form field calculation returning 2x correct result Jschueller Word 1 08-20-2013 01:51 PM
Prevent Field Calculation with Dates from introducing line break? ztag Word 1 01-13-2012 04:13 PM
Simple Calculation with a Merge Field Mail Merge Calculation Error Lsbutler2000 Mail Merge 1 06-22-2007 06:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft