Universal Containers has a dashboard for Sales Managers to visualize the YoY Growth of their customers. The formula used is: YoY = [(This Year – Last Year) / Last Year] % Based on the graphic, when there is no 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?

QuestionsCategory: Certified Tableau CRM and Einstein Discovery ConsultantUniversal Containers has a dashboard for Sales Managers to visualize the YoY Growth of their customers. The formula used is: YoY = [(This Year – Last Year) / Last Year] % Based on the graphic, when there is no 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?
Admin Staff asked 4 months ago
Image
Universal Containers has a dashboard for Sales Managers to visualize the YoY Growth of their customers. The formula used is: YoY = [(This Year - Last Year) /
Last Year] %
Based on the graphic, when there is no 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. coalesce()

B. number_to_string()

C. substr()

D. replace()








 

Suggested Answer: A





This question is in Certified Tableau CRM and Einstein Discovery Consultant Exam
For getting Salesforce Certified Tableau CRM and Einstein Discovery Consultant















Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Salesforce. 
Trademarks, certification & product names are used for reference only and belong to Salesforce.
The website does not contain actual questions and answers from Salesforce's Certification Exams.

Recommended

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.