## Level 2 Sprint 2 Forecast cf formula

Frequent Contributor

## Level 2 Sprint 2 Forecast cf formula

I have been struggling with my formulas and I just wanted to check that my Forecast cf formula was correct.  It worked the first time which made me nervous.

The instructions are:

• 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

My formulas is: IF Initial Demand Forecast = Final Forecast THEN 0 ELSE 1

7 REPLIES 7
Certified Master Anaplanner

## Re: Level 2 Sprint 2 Forecast cf formula

Hey @LStinsa,

Based on the description you have provided here in the instructions and the formula you came up with, it seems to satisfy the instructions,

Are you seeing some kind of error message or some issue with the data? Can you help clarify what might be making you nervous here? Is the formula not working the way you thought?

Frequent Contributor

## Re: Level 2 Sprint 2 Forecast cf formula

Further down in the lesson we have to create a saved view and they give an example.  My data does not match the example and I'm trying to figure out why.

This is the example they give:

This is what mine looks like:

It looks like I"m off by one in my Final Forecast so I was wondering if its was my Forecast cf formula

Certified Master Anaplanner

## Re: Level 2 Sprint 2 Forecast cf formula

Tagging @JaredDolich who is more in-tune with the training models.

@LStinsa - are you able to provide screenshots of the blueprint view in this module? Seeing the blueprint will help narrow this down.

Also are you able to provide screenshots of the source data?

2 possibilties here:

1) Possible formula logic missing that we need to add, so that the extra 1 gets captured in the formula

2) This might be a data issue upstream where the numbers are not adding up.

Frequent Contributor

## Re: Level 2 Sprint 2 Forecast cf formula

This is my blueprint view for DEM03:

Moderator

## Re: Level 2 Sprint 2 Forecast cf formula

You're good. You're not the first person to call that out. If you're interested, I would recommend sending a note to academy@anaplan.com. It's optional but it might help them get the right screenshot in that course.

Good job though! I looked at all your formulas and they look great. Nicely handled!

Jared Dolich
Frequent Contributor

## Re: Level 2 Sprint 2 Forecast cf formula

Thank you again for your help!

New Contributor

## Re: Level 2 Sprint 2 Forecast cf formula

In the Course, that image has been given just as a reference for the view but not for the data comparison. Kindly, Note it.