Formula Error

Hi,

I have a list of 'Brands' which is a production list. I know that 'select' function does not work with prod list members however, it should work with the list top member/ highest level . But when I am using it with the highest level i.e. 'All Categories' I am getting an error that the list member or version is not recognised in the model. Please help me understand the reason/ meaning of this particular error.

Thanks in advance!

Accepted answers

nikolay_denisov

Hello,

If I get it right you have a 4 level nested hierarchy,

And your formula is correct, it is just a problem of a Top Level Item.

You need to check each setting of a top level items in each of a list:

P1 - All Products

P2 - No Top Item setting

P3 - No Top Item setting

P4 - All Subcategories

It happens formula error if your top level Item for P4 is different from P1. So you would need to click on settings gear->go to the lists->open P1 list-> click on a top level item.

Also I agree that you dont need if-then-else statement for simple comparisons like XXX<>0, it is much simpler to use boolean logic

All comments

filip.sypniewski

Hi @CommunityMember131357,

can you attach a screenshot of your list with top level, and formula you are trying to write?

Are you typing your top level manually or selecting from the list? This is often reason of such an error.

Misbah

@CommunityMember131357

As @filip.sypniewski said it could happen if you are typing the name of your top level leading to inaccuracies. What you can do is after select statement go to the list and point it to the top level instead of writing the name of the top level.

Kanishq17

Hi @CommunityMember131357

It should work fine, as @Misbah , instead click on the top level item of the production list

CommunityMember131357

Hi @Misbah, @filip.sypniewski , @Kanishq17

I am writing the formula after selecting it directly from the list only. Attached is the screenshot of the formula and the error that I am getting. Formula error.JPG

Thanks in advance for your help.

Misbah

@CommunityMember131357

Confirm that your source module has P4 Brand as a dimension and your target module doesn't have it.

If yes, then you don't need to write SELECT statement on All Categories. Anaplan will automatically pull the top level into target module.

Your formula should be

123 = IF 'internal P&L - w/o time'.Structure cost<> 0 then TRUE else FALSE

or simply write

123 = 'internal P&L - w/o time'.Structure cost<> 0

as there is no need of IF else statement

CommunityMember131357

Hi @Misbah ,

Thanks for your reply but however the target and the source module both have the list 'P4 Brand' as a dimension. So, any idea on around why this is happening?

Thanks in advance!

Misbah

@CommunityMember131357

Then my friend SELECT statement can't be used. SELECT is used when you have a dimension which is in source module but not in target module. Either you get rid of the P4 dimension in target module & use SELECT or just get rid of SELECT which will not help you the way you describe your requirement. First approach should help you where you remove the P4 as a dimension from your target module.

Error that you are receiving might be because you have the dimensions matching and you are using SELECT on matching dimensions.

CommunityMember131357

Hi @Misbah,

Thanks for your reply.

I have removed P4 List Dimension from the target module and kept only in the source module but still it's not working and giving me the same error.

nikolay_denisov

Hello,

If I get it right you have a 4 level nested hierarchy,

And your formula is correct, it is just a problem of a Top Level Item.

You need to check each setting of a top level items in each of a list:

P1 - All Products

P2 - No Top Item setting

P3 - No Top Item setting

P4 - All Subcategories

It happens formula error if your top level Item for P4 is different from P1. So you would need to click on settings gear->go to the lists->open P1 list-> click on a top level item.

Also I agree that you dont need if-then-else statement for simple comparisons like XXX<>0, it is much simpler to use boolean logic

CommunityMember131357

Hi @nikolay,

Thanks for your help.

This way we have been able to execute the formula. But however both the lists had same parent i.e. 'All Categories'. So any idea why this happened?

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…