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?
AJE68
1 year ago