Trigger DB Alerts If Value > 0
A Planner has done preliminary forecasting for a product which is in the last stage of its life cycle (decline stage) so after doing preliminary forecasting he wants to incorporate the effects of life cycle to this product. So he will be having a row with the key figure as ‘ Adjusted forecast’ in his planning table. This row will contain adjustment on preliminary forecast due to life cycle stage & should be having negative values. So, if some positive value comes in the table , planner should be informed about this. This macro will trigger an alert with the value shown so that planner can take appropriate action. If this is not the case, this macro will delete all previous alerts in this context.
In the example, row 1 represents the preliminary forecast and row 2 the adjusted forecast.