Level 1 Model Building

[krw6]

I'm not exactly sure what I'm entering wrong that's not allowing this function. (Images Attached)

[JaredDolich]

@krw6 

Again, so so close!

I think you're just missing the right bracket at the end of that formula!

Watch out for single quotes and commas too! Sometimes those get missed.

'REV04 Price Growth Rates'.Cost Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

[krw6]

 I tried doing it manually and also copy/pasting yours, but i'm still receiving an error.

[JaredDolich]

@krw6 

Make sure you're spelling the line items exactly as you created them.

Can you show me the blueprint of these modules? Copy all the way to applies to.

• REV04 Price Growth Rates
• SYS04 Location Details
• SYS06 Product Details

I'm sure it's something very simple. Let's get you to the finish line!

[krw6]

I can't get anything to work !

[JaredDolich]

@krw6 

Hang in there! Take a break - learning Anaplan for the first time is a learning curve but I promise you'll get through it.

When you get a chance, screenshot those module above and I'll work out what's causing the problem.

Deep breath!

[JaredDolich]

@krw6 

Can you screenshot the blueprint mode for each of those?

I just wanted to check the spelling and the formulas.

[JaredDolich]

@krw6 

found it!

SYS04 still has the time hierarchy in it. Remove the calendar by setting the time scale to "Not Applicable"