Getting data from one module to another

CommunityMember127578

Hi,

I have two modules with project data.

The first module has a dimension of serial numbers (1,2,3,4). it is not a numbered list. One of the line items is defined as a list format of project numbers. this list is a numbered list.

 

The second module has a Dimension of the project numbers (numbered list). 

I need to pull data from the first module to the second one. I've tried the lookup function but it's doesn't work.

 

What function can I use?

 

thank you

Akhtar.shahbaz

Hi @CommunityMember127578 

 

You can use either FIRSTNOTBLANK or LASTNOTBLANK, you can see the example in below link

 

https://help.anaplan.com/3fafe6e5-7fe5-4211-847c-27e070285cf9-LASTNONBLANK

 

https://help.anaplan.com/en/153ec61a-a940-4d21-875a-aafe92e6e4ef-FIRSTNONBLANK 

Akhtar.shahbaz

Hi @CommunityMember127578 

 

You can use Sum function, below example may help you:

 

 

Thanks

Akhtar

CommunityMember127578

Most of the data is text so I can't use SUM