9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

FarisFarhan
Occasional Contributor

9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

I am trying to add the below formula to the line item (Unit Price %) in the REV05 Price Growth Rates Staging module and I keep getting the an error message 

 

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

 

The error message I am receiving is below. May somebody please help advise what I am doing wrong? 

 

The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid:

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

9 REPLIES 9
JaredDolich
Master Anaplanner/Community Boss

Re: 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

@FarisFarhan 

Make sure you are referring to the right line item in REV04. It's okay if you named it differently but you need to make sure it's spelled exactly the same.

Your Formula

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

Correct Formula:

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


Jared Dolich
FarisFarhan
Occasional Contributor

Re: 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

Hi Jared, 

 

First & foremost thank you for responding to my thread! Please see screenshots of module. Maybe this will help you, help me! 

     

REV05 Price Growth Rates Module.PNG

SYS04 Location Details Module.PNG

SYS06 Product Details Module.PNG

Formula I am getting error message on.PNG

REV04 price Growth Rates Module.PNG

JaredDolich
Master Anaplanner/Community Boss

Re: 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

@FarisFarhan 

Everything looks right except for one thing. You named your line item REV04.'Unit Price %' But the formula you entered is REV04.'Unit Price%' 

Try removing the space in REV04 between the word Price and the % sign, like this Price%.

See if that helps! 


Jared Dolich
FarisFarhan
Occasional Contributor

Re: 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

Jared I have added the space and still seem to be getting an error message 😞 

 

I don't know what I could possibly be doing wrong. I have been trying to work this error message for 2 weeks now!

 

FarisFarhan_0-1612985171780.png

 

JaredDolich
Master Anaplanner/Community Boss

Re: 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

@FarisFarhan 

You'll get it. Instead of typing the formula click on the line item. You may have a hidden character.

  • Double click on the formula line to put yourself into edit mode.
  • Go to REV04, click on the line item Unit Price %
  • Then type in the LOOKUP function
  • Go to SYS04 click on country
  • Type a comma
  • Go to SYS06 Click on Product Family
  • Add the right bracket 

Don't cut/paste the formula. Use the editor. Let's see if that improves things. If not, send me a private note to @JaredDolich let's set up a zoom call. I want you to get to the finish line on this.


Jared Dolich
FarisFarhan
Occasional Contributor

Re: 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

@JaredDolich 

 

I have attempted to add the formula by clicking on the line items as opposed to copying and pasting & I am getting the same error message.

 

However, I did notice something on my Model that was a little different then the model in 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module.

 

In my SYS06 Product Details module, the product family shows as "CH" and in the Lesson 9.25 module is shows as "Chocolate". Could this possibly be the reason for my error message? If so may you please advise how I can fix my module to match the Lesson 9.25. I attempted to do this on my own by going back to the earlier lessons but could not figure it out. 

 

Please see screenshots for your reference & thank you in advanced! 

 

FarisFarhan_0-1613490802568.png

 

FarisFarhan_1-1613490836799.png

 

JaredDolich
Master Anaplanner/Community Boss

Re: 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

@FarisFarhan 

Hang in there. The error you're getting is a syntax error. If you tried to refer to a list item that doesn't exist you would get a different error.

Try following this short video. Let's make sure your syntax is right.

REV05.gif


Jared Dolich
FarisFarhan
Occasional Contributor

Re: 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

@JaredDolich 

 

I have finally got this formula to work! I had once of my collogues assist me, I had time as a dimension in my SYS04 Location Details Module. 

 

Once I removed time as a dimension the formula worked!

 

 Thank you very much for your help Jared! 

JaredDolich
Master Anaplanner/Community Boss

Re: 9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module

@FarisFarhan You are so welcome!


Jared Dolich