The Universal Containers Admin is creating a custom formula field, Approval Score, on the Quote Line object to calculate approval score. This field will calculate the average approval score for the Quote to determine how many levels of approval the record should go through when submitted.
The Admin planned to use a roll-up summary field on the Quote object to average the Quote Line Approval Score field. The Admin received an error when attempting to create the field. The Quote object has too many roll-up summary fields.
In addition to creating a custom number field on the Quote object to capture the average Approval Score, which action Should the Admin take to resolve the issue?
- Create a trigger to populate the average Approval Score.
- Create a Summary Variable and Product Rule to populate the number field with the average Approval Score.
- Create a Workflow Rule with a Field Update to populate the average Approval Score.
- Create a Summary Variable and Price Rule to populate the number field with the average Approval Score.