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

Kimberlie

9 days 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

...

Gilberto

10 days 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

Herminia

2 days ago

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

upvoted 0 times

...

Vallie

19 days 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