function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

How to use 'Roll-Up Summary' for field which is a lookup for another object



I want to use  'Roll-Up Summary' in my header object (e.g. Invoice header) to sum a field (e.g. production cost) from invoice line item object (production cost field is a lookup from another object e.g. merchandise object)?


I can get other objects which are not lookup's (e.g. sale price from invoice line items) in Roll-Up Summary, but there is no pickvalue for 'production cost'.




You have to make it a "master-detail" relationship in order for it to be available as a rollup summary field object.


I do have the relationship with invoice line item and invoice header, that's how I got the sales total. But cannot get the 'production cost' total?


Are you suggesting I have to master relationship between invoice header and merchandise? Then, how do I filter products/merchandise which are available in invoice line items to roll-up?