Formula Help

Highlighted
Occasional Contributor

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

5 REPLIES 5
Highlighted
Super Contributor

Re: Formula Help

Hi @Rajasekhar,

 

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

Highlighted
Occasional Contributor

Re: Formula Help

Hi Filip,

 

I have the module as below:

Rajasekhar_0-1595401979690.png

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

 

Highlighted
Master Anaplanner/Community Boss

Re: Formula Help

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

 

 

 

Highlighted
Occasional Contributor

Re: Formula Help

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

Highlighted
Master Anaplanner/Community Boss

Re: Formula Help

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

@~Vignesh M