View Single Post
 
Old 12-30-2019, 10:29 AM
shawn.low@cox.net shawn.low@cox.net is offline Windows 10 Office 2016
Novice
 
Join Date: May 2019
Location: Aliso Viejo, CA.
Posts: 24
shawn.low@cox.net is on a distinguished road
Default Simple Calculation with a Merge Field

Good Morning,


I am trying to write the code that takes a merge field, and subtracts 1, and displays the result.
Here is what I have, does it look correct?


{{= {MERGEFIELD TableStart:BorrowerProductQuery \*MERGEFORMAT}{MERGEFIELD Selected_Product_Term_Months \* MERGEFORMAT}{MERGEFIELD TableEnd:BorrowerProductQuery \*MERGEFORMAT} - 1 \# "0" *MERGEFORMAT}}


I am using Conga Composer to "build" the Word Doc, and the Merge Field is coming from a Conga Query, hence the "TableStart" & "TableEnd" merge fields.
The actual field value I need is called "Term_Months".


An example is, if the "term" of a loan is 60 months (This is the value in the field Term_Months), I need need the formula to return a value of "59".


I hope this makes sense.
Is the formula correct?


Thanks Paul,
Shawn Low

Reply With Quote