I'm not exactly sure what I'm entering wrong that's not allowing this function. (Images Attached)
@krw6
Oh, just saw the new issue.
You have "volumes". I believe that should be "volume"
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]
I tried doing it manually and also copy/pasting yours, but i'm still receiving an error.
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.
I'm sure it's something very simple. Let's get you to the finish line!
I can't get anything to work !
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!
Can you screenshot the blueprint mode for each of those?
I just wanted to check the spelling and the formulas.
found it!
SYS04 still has the time hierarchy in it. Remove the calendar by setting the time scale to "Not Applicable"
Thank you so assisting me through this !
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.
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?
Yep, your solution worked perfectly!
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!!
Please help as getting this error using LOOKUP in Module 1
@Gayatri2020
Your formula is correct but you're adding it to the wrong module. Check REV05 - I think you'll find success there.
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
There was an error rendering this rich post.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
