Formula for Forecast cf

ykim85

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

"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?

 

eypoole

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!