5 Replies Latest reply: Aug 20, 2014 6:04 AM by JTF85 RSS

    Copying one scenario to another

    2728145

      Hi all,

       

      I'm trying to copy the budget to the forecast scenario:

       

      ---------------------------------------------------------------------------------------------------------------------------------------------

      Dim vScenario
      Dim vValue
      Dim vPeriod
      Dim vPeriodNum
      Dim vYear
      Dim vEntity
      Dim vScenarioUD1

      vScenario = HS.Scenario.Member()
      vValue = HS.Value.Member()
      vPeriod = HS.Period.Member()
      vPeriodNum = HS.Period.Number()
      vYear = HS.Year.Member()
      vEntity = HS.Entity.Member()
      vScenarioUD1 = HS.Scenario.UD1("")


      Dim val
      Dim strAccount
      Dim lngValid
      Dim aCustom4, StrCustom4

       

      'Copy Actuals and Budget into Forecast Scenario

       

      If vScenario = "Forecast_1" Then
        If HS.Value.Member() = "<Entity Currency>" Then
         HS.Exp "S#" & vScenario & ".W#Periodic = S#Budget.W#Periodic"
        End If
      End If

      --------------------------------------------------------------------------------------------------------------------------------------------

       

      This rule is not working, there is no data in the forecast scenario but I have data on the budget scenario.

       

      Does anyone have any idea that could help?

       

      Thank you in advance,

      Kim