Scenario Planning

CommunityMember111277

Hi Team,

I have an unique issue which requries a uinque..

Lets say I have a List called - "Scenarios"

-Scenario1

-Scenario2

-Scenario3

Using the list in a module called "Data Scenario"

I want to copy data of Net Sales from Scenario 1 to Scenario 3, I know I can use the import action, however in that case, I will have to manually map the scenarios. (1>3)

Is there a way to copy data from 1 scenario to another without the manual mapping in the Import action. Lets say, if we want to provide option to the user to create scenarios in future independtly & also copy data from one to another.

Thanks

AB

HimanshuRaj

Hi @CommunityMember111277

You can create 2 more line items in same module,

1. same scenario list formatted line item - 2nd line item
2. Number format line item - 3rd line item

User will select Scenario 1 against scenario 3 in 2nd line item - that'll mean user needs to copy scenario 1 data to scenario 3

Apply formula in 3rd line item: Data[lookup: 2nd line item]. That'll pull 5000 in 3rd line item against scenario 3 and then , based on a filter logic you can create an import to import data from 3rd line item to 1st line item

Cheers!!