Info Message If Sum > 1000
A demand planner is responsible for creating both a baseline forecast and promotions. It is the policy of his company that when forecasted demand in a year is greater than 1000 units, promotions are not planned for that year because the company does not have the capacity to produce more than 1000 units. The macro triggers a message to inform the planner when the forecast is greater than 1000. He is therefore saved the unnecessary effort of planning promotions in that year.
In this example, row 1 represents the baseline forecast.