PDI · Question #34
Universal Containers stores the availability date on each Line Item of an Order and Orders are only shipped when all of the Line Items are available. Which method should be used to calculate the…
The correct answer is D. Use a Max Roll-Up Summary field on the Latest availability date fields. To determine the order's ship date based on the latest availability of all line items, a Roll-Up Summary field configured to find the maximum availability date from the child line items should be used on the parent Order object.
Question
Universal Containers stores the availability date on each Line Item of an Order and Orders are only shipped when all of the Line Items are available. Which method should be used to calculate the estimated ship date for an Order?
Options
- AUse a CEILING formula on each of the Latest availability date fields.
- BUse a DAYS formula on each of the availability date fields and a COUNT Roll-Up Summary field
- CUse a LATEST formula on each of the latest availability date fields.
- DUse a Max Roll-Up Summary field on the Latest availability date fields.
How the community answered
(24 responses)- A4% (1)
- B4% (1)
- D92% (22)
Why each option
To determine the order's ship date based on the latest availability of all line items, a Roll-Up Summary field configured to find the maximum availability date from the child line items should be used on the parent Order object.
A `CEILING` formula is used for rounding numbers up, not for finding the latest date among a set of records, and it's typically applied to a single field, not across child records.
A `DAYS` formula calculates the number of days between two dates, and a `COUNT` Roll-Up Summary counts records, neither of which determines the single latest date.
A `LATEST` formula (not a standard Salesforce formula function for this aggregation) would not automatically find the maximum date across multiple child records.
A Max Roll-Up Summary field on the Order object, aggregating the 'Latest availability date' from its child Line Item records, correctly identifies the latest date among all line items, which is the earliest an order can ship if all items must be available.
Concept tested: Roll-Up Summary fields for aggregation (MAX)
Source: https://help.salesforce.com/s/articleView?id=sf.fields_about_roll_up_summary_fields.htm&type=5
Topics
Community Discussion
No community discussion yet for this question.