Forum Discussion

Marco's avatar
Marco
Contributor II
7 months ago

How do I clean a scenario before copying data from another scenario? in the member formula.

Hi Everyone. I want to copy the information from one scenario to another. Currently, I’m using the member formula of the target scenario to transfer the data. However, I first apply a calculate to s...
Finance
System
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
7 months ago

You can clear a scenario (completely, all nodata) by running the Reset Scenario data management step, then with another data managment step, copy the data.  Perhaps a bit easier to build and maintain than similar calculations in code. 
Also note, I wouldn't perform clear then copy in a member formula.  That could cause problems and the next guy will never be able to find it.

 

  • Marco's avatar
    Marco
    Contributor II
    20 days ago

    Hi Robb,

    the problem is that I run my copy data process when I consolidate a scenario and use the formula within the scenario.