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?
- replace()
- number_to_string()
- coalesce()
- substr()
Reveal Solution
Next Question