Formula Help

Rajasekhar
Rajasekhar
in Modeling

Hi,

 

I have a module with Versions list(version1, verrsion 2, Version 3 in Line items) in dimension. I want to copy Line item 1 of version 1 to Line item 2 of version 2. 

Please let me know how to write the formula.

 

Also if I have 2 similar modules and I want to copy Line item 1 of version 1 from Module 1 to Line item 2 of version 2 module 2. Please let me know how to write the formula.

 

Please help me on the above 2 scenarios.

 

Regards,

Rajsekhar

Tagged:

Answers

  • filip.sypniewski
    filip.sypniewski

    Hi @Rajasekhar,

     

    can you provide screenshot of your module including dimensions and line items? It is not completely clear what is the case. 

  • VIGNESH.M
    VIGNESH.M

    Hi Rajasekhar,

     

    I am assuming you are using Custom Version List(i.e..Version 1, Version 2 & Version 3) .

     

    You need to use LOOKUP to get value from Version 1 to Version 2 as shown below. Try this.

    I have created a separate module for version lookup and formated the line item as version list and manually selected the version and used it in the Calculation module for lookup.

    Pic 1.png

    The same method can be used to bring data from one module to another module.

    ~Vignesh M

     

     

     

  • Rajasekhar
    Rajasekhar

    Hi Vignesh,

    I have as module like below:

     

    Rajasekhar_0-1595401887950.png

    I want the Green to get copied to yellow. Please can you help on the same.

     

    Regards,

    Rajsekhar

  • Rajasekhar
    Rajasekhar

    Hi Filip,

     

    I have the module as below:

    Rajasekhar_0-1595401979690.png

    I want to copy from Green to  Yellow. Please can you help.

     

  • VIGNESH.M
    VIGNESH.M

    Hi @Rajasekhar , Try my above solution, it will work perfectly for this scenario.

    @~Vignesh M

Categories