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
|