Level 1 Model Building

Highlighted
Contributor

Level 1 Model Building

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

15 REPLIES 15
Highlighted
Master Anaplanner/Community Boss

Re: Level 1 Model Building

@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]


Jared Dolich
Highlighted
Contributor

Re: Level 1 Model Building

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

Highlighted
Master Anaplanner/Community Boss

Re: Level 1 Model Building

@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!

 


Jared Dolich
Highlighted
Contributor

Re: Level 1 Model Building

I can't get anything to work !

Highlighted
Master Anaplanner/Community Boss

Re: Level 1 Model Building

@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!

 


Jared Dolich
Highlighted
Contributor

Re: Level 1 Model Building

 
Highlighted
Master Anaplanner/Community Boss

Re: Level 1 Model Building

@krw6 

Can you screenshot the blueprint mode for each of those?

I just wanted to check the spelling and the formulas.


Jared Dolich
Highlighted
Contributor

Re: Level 1 Model Building

 
Highlighted
Master Anaplanner/Community Boss

Re: Level 1 Model Building

@krw6 

found it!

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

BigChallenge001.png


Jared Dolich