Compare two lines items from different modules

SofianeLz · 2024-04-03T16:27:01+00:00

There was an error rendering this rich post.

Hello

This is my problem.

I have a line item A in one module dimensioned by "Depense" list.
And I have the line item B in another module dimensioned by "Achat" list.

I want to compare if A = B then the item of the list Achat become the parent of the item of the list Depense.

I cannot pull any finditem.

Is there a way to do it ?

Thanks

Accepted answers

All comments

Dikshant

you need to establish the mapping b/w both lists in order to compare it…

jagadishdash

@SofianeLz Does both of your list "Depense" and "Achat" having any relation? if not you have to meet the relation mapping between two as per your requirement.

SofianeLz

@Dikshant @jagadishdash
Thanks for the answers, indeed I need a mapping between them, but its hard to find any item in common between them, gonna look deeper

Dikshant

Oh may be I got your question now, you need to flag the items which are common in both list?

Create a module and apply both lists as a dimension. Then create a Boolean and a formula to compare the codes or names of both the lists.

NAME(ITEM(Achat)) = NAME(ITEM(Depense)) if both are flat list

CODE(ITEM(Achat)) = CODE(ITEM(Depense)) if both are numbered list

let me know if this is what you're looking for?

jagadishdash

Above Dishkant's suggestions will work to create a mapping between two list with taking the both dimension.

If that doesn't works, let us know the exactly what you're facing if possible with screenshots.

Jaintanya

Hi, i have two modules with same line item. I want to compare if an item from one module is present in the line item in the other module. How can i do that? ITEM function is not working. I get this error that item only works with hierarchy.

seymatas1

@SofianeLz

Here are the step-by-step instructions on how I created a similar structure:
1. I created List 1 and List 2.

Screenshot 1: List 1

Screenshot 2: List 2

2. I created a presence mapping module, dimensioned by List 1.
Screenshot 3: Presence Mapping Blueprint View

Screenshot 4: Presence Mapping Grid View

You can build a two-way comparison using the same logic. Let me know if this helps.

seymatas1

@Jaintanya
You can compare line items of two modules by creating line item subsets.

Here is how I structured it:

Screenshot 1: Module 1

Screenshot 2: Module 2

Screenshot 3: Line Item Subsets

Screenshot 4: LIS04: Line Item Comparison - Module 1

Screenshot 4: LIS05: Line Item Comparison - Module 2

Screenshot 4: Module 1 Comparison grid view

Screenshot 5: Module 1 Comparison blueprint view

Screenshot 6: Module 2 Comparison grid view

Screenshot 7: Module 2 Comparison blueprint view

I wanted to note that line item subsets are lists. You can use both ITEM() and FINDITEM() formulas on line item subsets.
There could be a shorter solution if we could dimension a module by two line item subsets. We would create one module and dimension it by both line item subsets.

Let me know if this helps.

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