Salesforce Exam ANC-301 Topic 9 Question 23 Discussion

Actual exam question for Salesforce's ANC-301 exam

Question #: 23
Topic #: 9

Exhibit.

Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is:

YoY = [(This Year --- Last Year) / Last Year] %

Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value.

What is the correct function to use?

Asubstr()

Bcoalesce()

Creplace()

Show Suggested Answer

Suggested Answer: A

by Dorthy at Dec 10, 2023, 08:34 PM

Limited Time Offer

25%

Off

Get Premium ANC-301 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Shenika

2 months ago

I'm feeling like a sales manager right now, and all I can think about is how much I'd love to see those 100% YoY growth numbers instead of those null results. Coalesce() to the rescue!

upvoted 0 times

...

Filiberto

2 months ago

Coalesce() is the way to go! It's like a superhero function for replacing those pesky null values. Null be gone!

upvoted 0 times

Bobbye

6 days ago

C) replace()

upvoted 0 times

...

Allene

7 days ago

B) coalesce()

upvoted 0 times

...

Leonora

1 months ago

A) substr()

upvoted 0 times

...

Luis

2 months ago

The replace() function could work, but it's not the most efficient option. Coalesce() is specifically designed for this kind of data transformation.

upvoted 0 times

Cherrie

16 days ago

Let's go with coalesce() then.

upvoted 0 times

...

Pamella

17 days ago

I agree, coalesce() is specifically designed for this kind of data transformation.

upvoted 0 times

...

Nathan

19 days ago

I think coalesce() is the best option here.

upvoted 0 times

...

Alaine

2 months ago

The substr() function doesn't seem to be the right choice here. We need to replace the null values, not extract a substring.

upvoted 0 times

...

Tarra

2 months ago

I think the correct function to use is coalesce(). This function will replace the null values with the specified value, which in this case should be 100%.

upvoted 0 times