Level 1 9.2.5 Unit Price %

Minori1102
Minori1102
in Modeling

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

image.png

Any help is appreciated. Thanks.

Best Answers

  • AjayM
    AjayM
    Answer ✓

    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!

  • Dikshant
    Dikshant
    Answer ✓

    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.

Answers

  • Minori1102
    Minori1102

    Good day.
    Thank you very much for your kind support！
    The problem is solved.

Categories