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]
Comments
-
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]
0 -
Hi Jared,
First & foremost thank you for responding to my thread! Please see screenshots of module. Maybe this will help you, help me!
0 -
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!
0 -
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!
0 -
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.
0 -
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!
0 -
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.
0 -
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!
9 -
@FarisFarhan You are so welcome!
0 -
I had the same problem, it helped me a lot. Thanks for sharing!0
-
Hi,
Can anyone tell me how to add 5% in the unit cost %
1 -
@FarisFarhan that works! Thanks for sharing
0 -
Thanks @JaredDolich @
FarisFarhan. Helped me as well.0
