Create Custom Formula Fields on Consumer Goods Objects
Custom formula fields can help you access and understand data at a glance without any
manual calculations. Values in formula fields are automatically calculated based on other fields.
You can create custom formula fields on some of the key Consumer Goods objects.
Required Editions
Available in Lightning Experience in Professional, Unlimited, and
Enterprise Editions that have Consumer Goods Cloud enabled.
From
Setup, open Object Manager, and select the object that you want to create formula fields
on.
You
can create formula fields on any of these objects:
Assessment Indicator Definition
Assessment Task
Assessment Task Content Document
Assessment Task Definition
Assessment Task Indicator Definition
Assessment Task Order
Assortment
Assortment Product
Delivery Task
In-Store Location
Promotion
Promotion Channel
Promotion Product
Promotion Product Category
Retail Location Group
Retail Store
Retail Store KPI
Retail Visit KPI
Store Action Plan Template
Store Assortment
Store Product
Visit
AI Visit Recommendations
AI Visit Recommendation Requests
Image
Select Fields & Relationships, and then click
New.
From the Data Type list, select Formula, and click
Next.
Enter a field label and select a formula return type.
Click Next.
Enter your formula and click Check Syntax to ensure its syntactical
accuracy.
Optionally, enter a description and help text for the formula field, and click
Next.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.