Getting error while applying lookup

Getting an error that

The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid:

Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details Module'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

'REV04 Price Growth Rates'.Unit Price% is not a recognized line item or list member

Accepted answers

All comments

Noemi.andres

Hi @Kunal0489

If you could share more details regarding your source module and target module's dimensionality that would be helpful. Also, as your line item name has a special character you will need to ensure it has the single quotes before and after the name, so please try the following formula:

Unit Price % = 'REV04 Price Growth Rates'.'Unit Price%'[LOOKUP: 'SYS04 Location Details Module'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

Regards,

Noemi

Misbah

@Kunal0489

Looks like, due to special character % in your line item you may have to use single quotes or alternatively simply click and refer the line item if you are not doing that already

Misbah

AdamCookson

I would check the spacing on the Unit Price and the % symbol as well, if it's not matching it will throw out an error. As mentioned above, clicking on the line item you want should work around the issue.

Adam

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385