Importing data Module-to Module

Options
vlaxmi1
vlaxmi1 Member, ALL USERS, Community Member Posts: 2 New Contributor
in Extensibility

I’m trying to put Lookup and SUM function but every time it says ‘The formula is invalid’  and it doesn’t exactly tell what is the problem.

I want to import data in Module F from Module A and Module B.

I tried to use below formula for importing Module A data to Module F as they both have same dimension so i thought it would be easy to import but I got below error:

 

In Module F, Writing formula for Capacity as  -> Module A.Capacity [Lookup:D1, Lookup D2]

 

** Line items are all numbered format. Attaching screenshot for clarity.

Any suggestion would be appreciated.

Tagged:

Comments

  • vlaxmi1
    vlaxmi1 Member, ALL USERS, Community Member Posts: 2 New Contributor

    Thanks! It did work 🙂 So when dimension are same it will import but can you also suggest when dimension are different like for source module 2( my both dimension are different, D3,D4) Than Target module ( which has D1,D2 Dimension) but i have created an another source module 3 (which has 1 line item as list (matching to target module D1) and which is parent of D3)

     

Categories