9.2.5 Activity: 5.0% not carried forward

Hi,

Need help for 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

It was said to enter 5.00% for the FY19 Unit Cost % in REV04 Price Growth Rates module,
but it hasn't carried forward to the Unit Cost% for FY19 in REV05 Price Growth Rates Staging module.

Please refer the screenshot for reference.

- Gourav

Tags

Modeling

Calculation Functions

Accepted answers

All comments

You're very close. To make the connection between REV05 and REV04 you have to from G2/P1 to G3/P2. So in both cases we need to use a LOOKUP. You can find these relationships in SYS04 and SYS06, respectively. So your formula will look similar to this:

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

From what I can tell your modules are set up correctly, so this should work. Good luck!!

Hi Jared,

If I have understood correctly, do I need to add formula in REV04 Price Growth Rates module as well?

No formula needed in REV04, just REV05. Check your formula in REV05 with the one I provided.

The formula do matches as per yours which was provided.

Attaching screenshot for your reference.
I also attached dimensions screenshot.

REV05_126990.PNG

Dimensions_126990.PNG

Your formula looks great! What summary method do you have on your REV04 formulas?

@JaredDolich,

Summary method I have given Average

Let's take a look at your system modules then. Can you make sure all your list items are present in SYS04 and SYS06 and you have mapped your country and product family correctly?

Please find attached the screenshots of system modules.

I have mapped it correctly.

- Gourav

SYS04_127004.PNG

SYS06_127004.PNG

We're close. It's something simple. Can you take a screen shot of your modules? Let me check the lists and calendars.

@JaredDolich

In the learning it was mentioned to copy REV04 and paste and do necessary changes like name change/dimensions change.

I did it accordingly which did not help me to carry forward the 5.0%.

Now when I deleted the REV05 module and recreated manually rather than copying, the 5.0% automatically carried forward.

Thank you so much Jared for your time and help.

- Gourav

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…