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] 

11 REPLIES 11
dorfano
New Contributor

I had the same problem, it helped me a lot. Thanks for sharing!
Shubhamjuyal
New Contributor

Hi, 

 

Can anyone tell me how to add 5% in the unit cost %