Level 1 9.2.5 Unit Price %
Hi,
When I try to copy and paste this formula I get the below error and cannot seem to work this one out.
The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid:
Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP:'SYS04 Location Details'.Country, LOOKUP:'SYS06 Product Details'.Product Family]
'REV04 Price Growth Rates'.Unit Price% is not a recognized line item or list member
Any help is appreciated. Thanks.
Best Answers
-
Since there is a special character in the name of lineitem, you better refer the REV04 lineitem while in formula edit bar of REV05, rather than a copy-paste.
Cheers!1 -
Right - Copy paste don't work with copy paste. If there is a special character in module or line item name then you have to surround it with single quote. Otherwise you can always refer the line items for simplification.
1
Answers
-
Good day.
Thank you very much for your kind support！
The problem is solved.0