Formula for Forecast cf


I was working on the formula for Forecast cf and wrote out this formula as instructed.

Screen Shot 2020-11-26 at 4.26.00 PM.png

"IF Initial Demand Forecast = Final Forecast THEN Forecast cf = 0 ELSE Forecast cf = 1"


However, I am met with an error stating that Forecast cf line item has a number format, but the formula is question resolves to a Boolean format. Changing the forecast cf line item format to Boolean is not the answer so I was wondering what was wrong with my formula?



  • Hi there!


    I just completed my formula for Forecast cf line item & mine was similar to yours, but I did not include "Forecast cf = 0" or "Forecast cf = 1" as that is implied since it is the line item of the formula.

    This is my formula: IF Initial Demand Forecast = Final Forecast THEN 0 ELSE 1


    Hope this works for you!

  • Thank you!