Level 1 Model Building
I'm not exactly sure what I'm entering wrong that's not allowing this function. (Images Attached)
Best Answer
-
0
Answers
-
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]
1 -
I tried doing it manually and also copy/pasting yours, but i'm still receiving an error.
0 -
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!
0 -
I can't get anything to work !
0 -
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!
0 -
Can you screenshot the blueprint mode for each of those?
I just wanted to check the spelling and the formulas.
0 -
found it!
SYS04 still has the time hierarchy in it. Remove the calendar by setting the time scale to "Not Applicable"
0 -
Thank you so assisting me through this !
0 -
I hope i'm not annoying you at this point, I checked to make sure the other modules didn't have time as a factor and everything else I could think of.
0 -
Not a problem at all. Glad I can help.
Good lesson learned! System modules typically, not always, but most of the time only have one dimension. The dimension of the list. You have to remember to remove time when the module is first created.
Before we move on, did we fix the REV05 problem?
0 -
Yep, your solution worked perfectly!
0 -
Awesome! Let's mark that solved and start another post!
Now I'm determined to see you get to the finish line. When you get your certification I want to be the first to congratulate you!!
0 -
Please help as getting this error using LOOKUP in Module 1
0 -
Your formula is correct but you're adding it to the wrong module. Check REV05 - I think you'll find success there.
0
