Level 3 Sprint 1 Dat02

Options
prakashdevaguptapu
prakashdevaguptapu Member, ALL USERS Posts: 3 New Contributor
in Anaplan Community

HI EXPERTS,

 

I'm having an issue while bringing forward Data from one module FY19 to FY20 Module. Though Both the modules have same dimensions i.e., A2 Accounts>Product. Below is the Image for the target module after forwarding the data from Fy19 to Fy20 with formula .

 

prakashdevaguptapu_0-1636730957266.png

 

 

Here each product line item is capturing the sum of Accounts rather than corresponding individual Product values. Product values must be as represented in the below image.

prakashdevaguptapu_1-1636730957271.png

 

 

I tried to include lookup P2 Products from SYS03 Account>Product Details Module to resolve the issue, but the formula is not accepting the products line item with error: Format of mapping used for lookup doesn't match any dimension of the source. (*** in my Model, Dimensions are same for source sys03 and Target module  Dat03)

 

SYS03 Account>Product Details with formulas

prakashdevaguptapu_2-1636730957276.png

 

 

Need help!

 

 

 

 

 

Categories