Activity › Forums › Salesforce® Discussions › Can you have a roll up summary field in case of Master-Detail relationship?

Tagged: , , , ,

  • Avnish

    Member
    August 24, 2018 at 1:58 pm

    Hi Prachi,

    Yes. You can have a roll-up summary in case of a master-detail relationship. But not in case of a lookup relationship.

    A roll-up summary field is used to display a value in a master record based on the values of a set of fields in a detail record. The detail record must be related to the master through a master-detail relationship.

    There are 4 calculations that you can do using roll-up summary field. You can count the number of detail records related to a master record. Or, you can calculate the sum, minimum value, or maximum value of a field in the detail records.

    Thanks.

  • Parul

    Member
    September 12, 2018 at 4:06 am

    Hi,

    You have a roll up summary field only in case of Master-Detail relationship. Roll-up summary fields calculate values from a set of related records, such as those in a related list. You can create roll-up summary fields that automatically display a value on a master record based on the values of records in a detail record. These detail records must be directly related to the master through a master-detail relationship.

    The Roll up Summary field is basically of 4 types:

    Count
    Sum
    Min
    Max

     

    Thanks

  • shariq

    Member
    September 15, 2018 at 1:14 pm

    Hi,

    You can only have roll up summary field in case of master detail relationship and not in lookup case.

    Hope this helps.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos

Report

Harassment or bullying behavior
Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Mobile App Reported Contents
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .