Formula Help

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

Accepted answers

All comments

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

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

Hi Vignesh,

I have as module like below:

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

Regards,

Rajsekhar

Rajasekhar

Hi Filip,

I have the module as below:

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

VIGNESH.M

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

@~Vignesh M

Quick Links

Can you help?

Unanswered questions

Can Please explain the difference between a general list,a module,and action in Anaplan.
Can please explain why we create a general list ,a module,and Action ,and what purpose each one serves.🙂
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…