Getting data from one module to another
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?
You can use either FIRSTNOTBLANK or LASTNOTBLANK, you can see the example in below link
You can use Sum function, below example may help you:
Most of the data is text so I can't use SUM0