P2 Product and Product Platform Level 3

P2 Product and Product Platform is not populating any data, even though I tried to create Display name and using that in Formula FINDITEM(Product Flat, Display Name) and the message I am getting is "

Display Name is not a recognized line item or list member

Please advise. I am stuck here 😞

Accepted answers

All comments

TimothyThomas

Hi @PoojaGupta ,

You have the right idea for the formula, it's just your naming convention for Display Name that isn't quite right. The formula isn't recognizing Display Name because it's searching for a line item with that name within your SYS module. You need to rewrite the formula to make sure it's looking for the display name within the list you're referencing (in this case, I believe "A2 Account>Product#".

One other issue is that currently within the New Modeling Experience, you are unable to click on a list property within formula editor and have it populate the formula you are working on (which I believe is a known issue that is being worked on). This works in the classing modeling experience, otherwise you have to manually type it out right now if using the New Modeling Experience (which it looks like you are). In this case since the list contains special characters, you'll have to add single quotes around the list while writing the formula in the form: FINDITEM('P2 Product','*List Name*'.Display Name)

Hopefully that helps, please let me know if more detail is needed!

Thanks,
Timmy

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…