Deal of The Day! 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 Exam ANC-301 Topic 9 Question 23 Discussion

Actual exam question for Salesforce's ANC-301 exam
Question #: 23
Topic #: 9
[All ANC-301 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

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
Tarra
17 days 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
Alecia
5 days ago
Yes, coalesce() is the correct function for replacing null values.
upvoted 0 times
...
Lakeesha
6 days ago
I think the correct function to use is coalesce().
upvoted 0 times
...
...
Fernanda
18 days ago
I'm not sure, but I think replace() function might also work in this case.
upvoted 0 times
...
Clarinda
26 days ago
I agree with Virgina, coalesce() function will replace null results with 100%.
upvoted 0 times
...
Virgina
27 days ago
I think the correct function to use is coalesce().
upvoted 0 times
...

Save Cancel