Red if (negative) growth <=-20%.
Green if (positive) growth >= +20% OR if there were NO prior YTD sales and there are sales this year to date. Otherwise
Yellow if growth > -20% and < +20%.
Health = (CASE WHEN Sales.CurrentYearGrowth <= -20 THEN '3' --'Red' if declining too much
WHEN Sales.CurrentYearGrowth >= 20
OR (Sales.CurrentYearGrowth IS NULL AND Sales.CurrentYearSales > 0)
THEN '1' --'Green' if good growth or (no PriorYTDSales and sales this year)
ELSE '2' --'Yellow' Sales.CurrentYearGrowth > -20 and Sales.CurrentYearGrowth < 20
END),
WHEN Sales.CurrentYearGrowth >= 20
OR (Sales.CurrentYearGrowth IS NULL AND Sales.CurrentYearSales > 0)
THEN '1' --'Green' if good growth or (no PriorYTDSales and sales this year)
ELSE '2' --'Yellow' Sales.CurrentYearGrowth > -20 and Sales.CurrentYearGrowth < 20
END),
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article