How to use merge fields inside formula fields in a document ?
To use merge fields inside a formula, enter your formula with merge fields as shown below. During the merge, Writer maps the values to the merge fields, executes the calculations and places the value in the document.
Example:
Here, the merge field Average Score is inserted inside the formula to ascertain the percentage.
Please refer to our help page for detailed information on formulas, named fields in a merge document, and steps to insert merge fields in formulas.
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Bigin?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
Related Articles
Working with Formulas in merge template
Formulas Please click here to head to formula help page to learn about supported functions, inserting a formula, referencing cell values, etc. Named fields - In merged documents In a lengthy merged document where you are required to insert the same ...Working with Fields
Supported field types Supported field types Description Possible Values in the data source Rendered as Notes Plain Text The value of the field is placed as a string in the document. “test” “test” You can select the field in the document and apply the ...Working with Formulas
When creating documents in Writer, some cases may demand the use of basic arithmetic and logical operations like adding or subtracting numbers, computing the average of numbers, or finding the largest or the smallest number. Writer lets you insert ...How to map document merge fields with names in data source?
Field Mapping gives the ability to map merge fields of the document to the record names in the data source linked to the document before merging or sending them out for signature. If the document is connected to a different data source that uses ...Create Merge Templates
Overview An organization might require sending out many documents in bulk to clients, employees, and its customers, which would contain content common to all the recipients and personalized or unique information that varies from one recipient to ...