Pre-Winter Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

Salesforce Certified CRM Analytics and Einstein Discovery Consultant Analytics-Con-201 Question # 10 Topic 2 Discussion

Salesforce Certified CRM Analytics and Einstein Discovery Consultant Analytics-Con-201 Question # 10 Topic 2 Discussion

Analytics-Con-201 Exam Topic 2 Question 10 Discussion:
Question #: 10
Topic #: 2

Exhibit.

Analytics-Con-201 Question 10

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?


A.

substr()


B.

coalesce()


C.

replace()


Get Premium Analytics-Con-201 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.