New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce ANC-201 Exam - Topic 2 Question 13 Discussion

Actual exam question for Salesforce's ANC-201 exam
Question #: 13
Topic #: 2
[All ANC-201 Questions]

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Ciara
4 months ago
Totally agree with coalesce()!
upvoted 0 times
...
Amie
4 months ago
Nah, replace() won't work for this.
upvoted 0 times
...
Sharita
4 months ago
100% for null? That's a bit surprising!
upvoted 0 times
...
Sherell
4 months ago
I think coalesce() is the right choice here.
upvoted 0 times
...
Gerardo
4 months ago
The formula for YoY growth is spot on!
upvoted 0 times
...
Dominga
5 months ago
I’m leaning towards coalesce() too, but I just hope I remember the syntax correctly during the exam!
upvoted 0 times
...
Nakita
5 months ago
I feel like substr() is more about string manipulation, so it probably isn't the right choice for this.
upvoted 0 times
...
Winfred
5 months ago
I think we practiced a similar question where we had to replace nulls with a default value. I want to say it was the coalesce() function.
upvoted 0 times
...
Huey
5 months ago
I remember we discussed how to handle null values in our practice sessions, but I'm not entirely sure which function to use here.
upvoted 0 times
...
Lashandra
5 months ago
Hmm, I'm not too sure about this one. I know the Reference Client is used for testing, but I can't remember if it's for making calls or just checking the connections.
upvoted 0 times
...
Kaycee
5 months ago
I'm a bit confused by this question. The organizational structure for the architecture practice could potentially be covered in multiple TOGAF architectures, like Business, Application, or Technology. I'll need to review the TOGAF materials again to be sure I understand the right approach here.
upvoted 0 times
...
Buddy
5 months ago
Hmm, this is a tricky one. I'm not entirely sure about the nuances of audit standards and when they may or may not apply. I think I'll need to re-read the question and options carefully to make sure I don't miss any important details.
upvoted 0 times
...
Pearly
5 months ago
I remember practicing a similar question where improved IT resource discovery was mentioned, so I think that might be one of the answers here.
upvoted 0 times
...
Olive
9 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
Aretha
8 months ago
User 3: Coalesce() is the way to go for replacing null results with 100% value.
upvoted 0 times
...
Bea
8 months ago
User 2: I don't think there is a 'nullesce()' function, but that would be interesting!
upvoted 0 times
...
Adelaide
9 months ago
User 1: Coalesce() is the correct function to use.
upvoted 0 times
...
...
Kimberlie
10 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
9 months ago
C) replace() is not the correct function to use.
upvoted 0 times
...
Alethea
9 months ago
B) coalesce() is the way to go. It's like a magic wand for null values.
upvoted 0 times
...
Emogene
10 months ago
A) substr() is not the correct function to use.
upvoted 0 times
...
...
Gilberto
10 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
Jesus
8 months ago
You're right, A) substr() wouldn't work here. Coalesce() is the way to go.
upvoted 0 times
...
Lonny
8 months ago
I'm not sure, but I think A) substr() might not be the correct function for this scenario.
upvoted 0 times
...
Diego
8 months ago
Yeah, I agree. Coalesce() is the function to use in this case.
upvoted 0 times
...
Dante
8 months ago
I think B) coalesce() is the right choice. It will replace null values with 100%.
upvoted 0 times
...
Kimbery
8 months ago
Coalesce() seems like the right choice to handle null values in this case.
upvoted 0 times
...
Julene
9 months ago
I'm not sure, but I think coalesce() is the correct function to use.
upvoted 0 times
...
Monte
9 months ago
Yeah, I agree. Coalesce() is the best option for this scenario.
upvoted 0 times
...
Herminia
10 months ago
I think B) coalesce() is the way to go.
upvoted 0 times
...
...
Vallie
10 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
Ronna
10 months ago
Thanks for the tip! I'll make sure to use coalesce() for replacing null values in my dashboards.
upvoted 0 times
...
Susana
10 months ago
I agree, coalesce() is the way to go. It will replace null values with the specified value.
upvoted 0 times
...
...
Lemuel
10 months ago
I'm not sure, but I think replace() might also work in this case.
upvoted 0 times
...
Alida
10 months ago
I agree with Paola, coalesce() would replace null results with 100%.
upvoted 0 times
...
Paola
11 months ago
I think the correct function to use is coalesce().
upvoted 0 times
...

Save Cancel