How to link parsed list back to List codes

Minhle246
New Contributor

How to link parsed list back to List codes

Hi,

 

I've created a module that contains a list with data that has 3 components of a list concatenated (to limit the number of rows).

The list data looks like this: CCCC_AAAAAA_DDD - with the C's being company code, A's being account code, and the D's being department code.

 

I now want to have another module that references this coding, I was able to parse the string out into the relevant components but when I select different Accounts, departments or company codes..it doesn't filter out the data like i'd expect.  Any help/thoughts around this would be appreciated on how to do this!

 

Below is an example of the data:

 

Minhle246_0-1629749942895.png

 

In the other module, I've split the data this way:

 

Minhle246_1-1629750011169.png

what's happening is that for a code, CCCC_AAAAAA_DDD - it's parsing the string but putting it into every combination (which I don't want).  the data should only exist for combinations that match.

 

 

 

2 REPLIES 2
ashish.banka
Super Contributor

Re: How to link parsed list back to List codes

@Minhle246 Have you tried using LOOKUP for Account, Company code and Department while referencing the amount? 

 

AB 

ChrisHeathcote
Community Boss

Re: How to link parsed list back to List codes

Use 3 SUM functions to calculate the sum value of the amount line conditional on all 3 criteria.

 

Make sure to create list formatted properties in the combined list for each separate list and use these to map the sum functions.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA