How do I find a line item in a list subset?

Hi, I have a module in which I'm trying to determine if accounts are within an account list subset, if so return TRUE, so that I can then filter those records to import to another module.

I cant get the finditem to work for me, is there another way to do it? I also tried using a line item subset, but failed...

the subsidiary view shows the correct items in the subset, but how do I check that the 'find x' items are in that list?

I must be missing something...any help or alternate method appreciated. I didn't want to manually list the subset accounts in a formula...

thanks!

Accepted answers

rob_marshall

@vazqulu1

Just know, creating a filter like that is a huge performance hinderance because Anaplan does not read those 3 conditions at the same time, it reads them one at a time. Meaning, it reads the data for the first filter condition, then of that returned data, it does another read for the 2nd filter, then another read for the 3rd condition which is why that is against best practice (Planual Rule 4.03-06).

Rob

JaredDolich

@vazqulu1

Just to add to @rob_marshall - try to create a single line item that performs all three of those filter conditions if possible. I can attest to the poor performance when you use too many filters.

All comments

rob_marshall

@vazqulu1

I think you are very close. Take a look at this:

I have a list with a subset define:

In my SYS Invoices module, I have a line item with the Applies To being the subset. Line item is formatted to Boolean with the formula being True.

When I exit the blueprint, since ss_Active: Invoices (the subset) is part of Invoices, it will show a check for the members that are in the subset

Also, doing it this way versus doing a finditem() is better for performance reasons.

Looking at your formula, it looks like the subset is on L4 but you are doing your finditem on L5. If this is correct and L5 rolls up to L4, then you will not be able to find it as the subset doesn't go down to L5. So, if L4 is a parent of L5 and the subset is on L4, then create a line item on L5 (formatted to L4) with the formula being: parent(item(L5)). Then you can do a lookup to the L4 subset: SYS L4.Subset?[lookup:the line item for parent of L5]

Hopefully, that is what you are looking for

Rob

alexpavel

@vazqulu1

Indeed, the subsidiary formatted line-item cannot be used directly as a "filter" in a saved view, but it can be referred in any formula.

In order to create a usable filter line-item, just create a new boolean line-item without a subsidiary view and refer in the formula the subset subsidiary formatted line-item

vazqulu1_*39348

Thanks for the replies. I ended up changing the subset to a text field in the list and using a lookup to determine if the account was in the list set or not. I didnt want to create additional line items to be able to test or refer to the items. Then my filter was just if TRUE.

Rob

Just to add to @rob_marshall - try to create a single line item that performs all three of those filter conditions if possible. I can attest to the poor performance when you use too many filters.

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…