please help to find correct answer

Question

What are two considerations for deciding to use a roll-up summary field?

Choose 2 answers

Roll-up summary field can be performed on formula fields, but if their formula contains an ⌗error result, it may affect the summary value.

Roll-up cannot be performed on formula field

Roll-up summary field do not cause validation rules on the parent object unless that object is edited separately.

Roll-up cannot be performed on formula fields that use cross-object references or on-the-fly calculations such as NOW()

Please tell me correct ans.

Raju Velayudhan · Accepted Answer

1.Roll-up cannot be performed on formula fields that use cross-object references or on-the-fly calculations such as NOW()

2.Roll-up summary field can be performed on formula fields, but if their formula contains an ⌗error result, it may affect the summary value

thanks.

Gug Chil · Answer

Hi Neelesh Gothania I think you are wrong! Roll-up can be performed on formula field    The best way to find out the answer is to check it by yourself, I've created a formula field on Opportunity which returns number, and then created a rollup summary on Account which couns the sum of my formula, and it works perfectly. For the second part please see the following link   https://help.salesforce.com/articleView?id=fields_about_roll_up_summary_fields.htm&type=5  ( https://help.salesforce.com/articleView?id=fields_about_roll_up_summary_fields.htm&type=5 ) A roll-up summary field can trigger workflow rules and field validations . However, workflow rules and field validations do not fire when the following changes cause a mass recalculation of roll-up summary values: Changing the roll-up summary definition (such as the object, function, or field being aggregated) Changing the expression of a formula field referenced in a roll-up summary field Replacing picklist values for picklist fields referenced in the roll-up summary filter Changing picklist record type definitions Changing currency conversion rates Changing price book entries Also, in the same link you can find the following statement: If a roll-up summary field doesn’t contain cross-object field references or functions that derive values on the fly, such as NOW or TODAY, it can calculate the values of formula fields. So the answer given by @Puja  is correct!

please help to find correct answer

Formulas

Aprendizaje relacionado

Más ayuda