Level 2 Model Building/ 2.4.7 Activity
Having a hard time figuring out how to write a formula for Line Item forecast cf in Module DEM03 Demand Forecast. The instructions are below.
Write a formula for the line item:
- If Initial Demand Forecast is EQUAL to the Final Forecast, set value of Forecast cf to 0.
- If Initial Demand Forecast is NOT EQUAL to the Final Forecast, set value of Forecast cf to 1.
I was thinking about using a IF THEN statement, but theses line items are all have Number Formatting and not Boolean.