## 9.2.5 Activity: 5.0% not carried forward

Frequent Contributor

## 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

10 REPLIES 10
Moderator

## Re: 9.2.5 Activity: 5.0% not carried forward

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

Jared Dolich
Frequent Contributor

## Re: 9.2.5 Activity: 5.0% not carried forward

Hi Jared,

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

## Re: 9.2.5 Activity: 5.0% not carried forward

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

Jared Dolich
Frequent Contributor

## Re: 9.2.5 Activity: 5.0% not carried forward

The formula do matches as per yours which was provided.

I also attached dimensions screenshot.

Moderator

## Re: 9.2.5 Activity: 5.0% not carried forward

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

Jared Dolich
Frequent Contributor

## Re: 9.2.5 Activity: 5.0% not carried forward

@JaredDolich,

Summary method I have given Average
Moderator

## Re: 9.2.5 Activity: 5.0% not carried forward

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?

Jared Dolich
Frequent Contributor

## Re: 9.2.5 Activity: 5.0% not carried forward

Please find attached the screenshots of system modules.

I have mapped it correctly.

- Gourav

Moderator

## Re: 9.2.5 Activity: 5.0% not carried forward

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

Jared Dolich