What is the correct function to use?

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 SalesManagers want to replace it with 100% value.

What is the correct function to use?
A . replace()
B. number_to_string()
C. coalesce()
D. substr()

View Answer

Answer: C