View Single Post
 
Old 12-30-2019, 11:17 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 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