Salesforce Exam ANC-201 Topic 2 Question 13 Discussion

Actual exam question for Salesforce's ANC-201 exam

Question #: 13
Topic #: 2

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

https://help.salesforce.com/articleView?id=bi_security_datasets_row_level.htm

https://help.salesforce.com/articleView?id=managing_the_sharing_model.htm&type=5

by Hermila at Feb 25, 2023, 02:17 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Olive

1 months ago

Coalesce() is the answer, no doubt. Though I do wonder, is there a 'nullesce()' function too? Asking for a friend.

upvoted 0 times

Adelaide

20 days ago

User 1: Coalesce() is the correct function to use.

upvoted 0 times

...

Kimberlie

2 months ago

B) coalesce() is the way to go. It's like a magic wand for null values. Beats having those pesky nulls all over the dashboard.

upvoted 0 times

Levi

15 days ago

C) replace() is not the correct function to use.

upvoted 0 times

...

Alethea

27 days ago

B) coalesce() is the way to go. It's like a magic wand for null values.

upvoted 0 times

...

Emogene

1 months ago

A) substr() is not the correct function to use.

upvoted 0 times

...

Gilberto

2 months ago

Hmm, I'm not sure. Maybe C) replace() could work too, but I think coalesce() is the more appropriate choice here. Got to love those Salesforce functions!

upvoted 0 times

Dante

4 days ago

I think B) coalesce() is the right choice. It will replace null values with 100%.

upvoted 0 times

...

Kimbery

6 days ago

Coalesce() seems like the right choice to handle null values in this case.

upvoted 0 times

...

Julene

11 days ago

I'm not sure, but I think coalesce() is the correct function to use.

upvoted 0 times

...

Monte

1 months ago

Yeah, I agree. Coalesce() is the best option for this scenario.

upvoted 0 times

...

Herminia

2 months ago

I think B) coalesce() is the way to go.

upvoted 0 times

...

Vallie

2 months ago

Definitely go with B) coalesce(). It's the perfect function to replace null values with a specified value. I learned this in my Salesforce admin training.

upvoted 0 times