官术网_书友最值得收藏!

Rollup summary fields 

A rollup summary field (RUS) field is very much like a formula field in that it also performs a calculation. However, this is based on child records, and only when these child records are part of a Master-Detail relationship!

It's used to summarize a numeric value based on (filtered) child records and can perform COUNT, SUM, MIN, and MAX.

It is recalculated whenever a transaction on these child records occurs in the following ways:

  • When a new child is created
  • When one of the children gets updated
  • When a child gets deleted

You can use filters to only pull values from specific child records. For example, let's say that we have a custom Invoice__c object that is related to the account as a Master-Detail relationship. In our Invoice__c object, we have an Amount field and a Status field. We could create a RUS field in the account that represents the total amount that is overdue, which is a calculation of the SUM operation of the Amount field on all related invoices, with a filter on the Status field that is equal to Overdue.

RUS performs an update of the record they reside in and can, therefore, be used to fire off other automation tools, such as WFRs, Process Builders, and more.
主站蜘蛛池模板: 南木林县| 荣昌县| 贵阳市| 合肥市| 门头沟区| 马尔康县| 九江县| 石楼县| 江安县| 乌拉特前旗| 河间市| 彭阳县| 克东县| 内江市| 盈江县| 辽阳市| 皮山县| 新竹市| 饶河县| 崇礼县| 乌审旗| 惠安县| 荔浦县| 工布江达县| 太原市| 霸州市| 印江| 深水埗区| 河津市| 达尔| 林芝县| 井冈山市| 仙居县| 手游| 隆尧县| 都安| 双流县| 垫江县| 沛县| 锡林浩特市| 莎车县|