Which two solutions prevent a formula field from being referenced by a Roll-Up Summary Field?
Suggested Answer: B, D
Get Premium Plat-Admn-202 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
A formula field cannot be referenced by a roll-up summary field if it contains a cross-object field reference or a time-based function. A cross-object field reference is a reference to a field from a different object, such as Account. Name on a Contact object. A time-based function is a function that returns the current date or time, such as NOW() or TODAY(). Option A and C do not prevent a formula field from being referenced by a roll-up summary field.
30 comments · newest first
FL
Florinda
5 months ago
I lean towards B and C. The CASE() function adds complexity too.
BE
Beata
6 months ago
A is a solid choice. Workflow updates can mess with formula fields.
LE
Lenna
6 months ago
D seems tricky. The NOW() function shouldn't affect referencing, right?
KA
Kattie
6 months ago
I agree with B. Cross-object references definitely cause issues with Roll-Up Summary Fields.
BE
Bettina
6 months ago
I feel like A and C could also be valid. They change how the formula works.
CA
Cassi
6 months ago
I think B and D are the right answers. Cross-object references can complicate things.
LA
Lashandra
6 months ago
Nope, CASE() is not an issue, just the cross-object stuff!
MI
Mila
7 months ago
I thought the CASE() function was fine for roll-ups.
KE
Kelvin
7 months ago
Wait, the NOW() function too? That's surprising!
EM
Emmanuel
7 months ago
Totally agree, that makes sense!
DO
Dortha
7 months ago
A cross-object field reference in the formula field prevents it.
NA
Nakita
7 months ago
I'm with David on this one. The NOW() function is about as useful for this problem as a chocolate teapot.
LA
Latrice
8 months ago
Haha, the NOW() function in option D? That's like using a hammer to fix a leaky faucet. Totally irrelevant!
VA
Valentine
8 months ago
The NOW() function in option D? Really? That's just a date/time function, not a solution to the problem.
JI
Jill
8 months ago
The CASE() function in option C is not the right solution. That's just a regular function in a formula field.
BE
Bettina
9 months ago
I think option A is also a valid solution. A cross-object workflow updating a field referenced by the formula field can prevent it from being used in a Roll-Up Summary Field.
MO
Mollie
9 months ago
Option B is the correct answer. A cross-object field reference in the formula field prevents it from being referenced by a Roll-Up Summary Field.
AN
Angella
9 months ago
I’m a bit confused about the cross-object workflow part; does that really prevent the roll-up from referencing the formula field?
LE
Lemuel
9 months ago
I feel like I’ve seen a question similar to this in practice exams, and I think the CASE() function was mentioned as an issue too.
ER
Erasmo
9 months ago
I’m not entirely sure, but I remember something about the NOW() function being problematic in formula fields.
DE
Derick
9 months ago
Alright, time to put on my thinking cap. I'll start by analyzing each of the options and how they could prevent the formula field from being referenced.
LO
Louvenia
10 months ago
I've seen questions like this before. I think the key is to focus on the specific solutions mentioned and how they might impact the formula field.
KE
Kenneth
10 months ago
I'm a bit confused on this one. I'll need to review the concepts around formula fields and Roll-Up Summary Fields.
IO
Iola
10 months ago
I think option B might be one of the answers since cross-object references can complicate roll-up summaries.
TA
Tamar
10 months ago
Okay, let's see. I think the key is understanding what can prevent a formula field from being referenced by a Roll-Up Summary Field.
AM
Amber
10 months ago
Hmm, this one seems tricky. I'll need to think through the different options carefully.
SA
Samira
3 months ago
I feel like D is a safe bet to rule out.
CE
Celestina
4 months ago
A could work too, but I’m not sure about C.
JU
Julieta
4 months ago
Yeah, B makes sense. What about A?
EL
Elly
4 months ago
I think B is definitely one of them.