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.
Anaplan Modelers: Has Anyone Recreated a Showcase Model for Learning Purposes? One of the most valuable learning resources I've come across is Anaplan's Modeling Showcase. It features sophisticated, real-world model examples that offer an incredible opportunity to learn how experienced model builders structure their…
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
