Mapping issue

HI,

I have one Account flat list which has code for every accounts. there is one more flat list account items which is related to items within the accounts. So one account can be related to many account items list. there is one list which consist of items levels (1-5 numbers). so now i want to have values of account based on sum of account items related to accounts and each level numbers. like if level are 1,2,3, 3 for account items a1, b1, c1, d1., account code is 1500 for all the items. it should sum accounts based on account code and the respective levels

How will i be able to get the value. Please help me with the solution.

Thanks

Pankhuri

Accepted answers

All comments

srikanthkamath

Hi, Could you please elaborate this issue with sample files or screenshots?

nathan_rudman

In your source module, where you have the data, you need to create a mapping line item formatted as List Account. You make a formula to map it based on the numbering of the account item.

You can then SUM the values by that line item in your target module which has Account as a list.

Kanishq17

Hi @Pankhuri

Is levels list a property of account items list or levels is a separate list and present as List formatted line item in account item module.

In that case , if you to aggregate level values by account, you need to find account name using finditem, and create a number formatted line item and convert levels number which is list formatted to a number format using value(name(levels)), then aggregate based on account in the target module

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…