Create a rollup summary field that determines the potential value of the opportunities associated with an account

Add a custom field to the standard account object that provides a rollup summary of the total expected revenue from all related opportunities.
  • The rollup summary field should be labeled Potential Value and have the Field Name of Potential_Value. The resulting API name should be Potential_Value__c
  • The rollup summary should calculate the total expected revenue of all the opportunities related to the account.

Create a validation rule to check that a contact is in the zip code of its account.

To complete this challenge, add a validation rule which will block the saving of a new or updated contact if the contact is related to an account and has a mailing postal code (which has the API Name MailingPostalCode) different from the account’s shipping postal code (which has the API Name ShippingPostalCode).
  • Name the validation rule Contact must be in Account ZIP Code
  • A contact with a MailingPostalCode that has an account and does not match the associated Account ShippingPostalCode should return with a validation error and not be saved
  • The validation rule should ONLY apply to contact records with an associated account. Contact records with no associated parent account can be added with any MailingPostalCode value. (Hint: you can use the ISBLANKfunction for this check)