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 theREV05 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 REPLIES11
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 %