Formula error while pulling data from one module to another

ankulkarni

Hello, 

My goal is to get the 'total volume' of product being used for certain year by different cities. 

Below are the two data set which have been successfully mapped into Anaplan

I want to pull data from DATA02 into REV02 to achieve my goal. 

SOURCE

 DATA02- (data SKU Volumes) 

 

TARGET: REV02- (data Volume Inputs)

 

I tried using LOOKUP function but somehow unable to use it. 

 

 

What is the right way to map data so that my goal is achieved?

 

Thanks

 

einas.ibrahim

Hi @ankulkarni 

 

I guess when you say "successfully mapped into Anaplan", by mapped you mean imported. Mapping means something else.

 

Generally, when we want to  reference a line item from a source module into a target module (where the data should end), we could have a couple of cases:

1. The dimensions of both modules are the same. In this case a direct reference such as Line Item = Sourrce Module. Line item will do the job.
2. The dimensions of the modules are different. In this case, we need to use mapping and a LOOKUP or SU 

Here are the dimensions of the module you mentioned. 

Module REV02 (Target) is dimensioned by: 

1. G3 Location  
2. P2 Product (Parent of P3)
3. Time: Months

Module DAT02 (Source) is dimensioned by:

1. G3 Location 
2. P3 SKU
3. Time: Months

Do you think we need to use direct reference or mapping here?