Forum Discussion

Beeswing77's avatar
Beeswing77
New Contributor III
2 years ago

Forecast Seeding not working for AdjInput

Hi, I'm trying to copy data from Actuals into Forecast,  but it seems to only work for Input and Forms Origin members, and not for Adj. Here is my formula, which I put on the Forecast Scenario: ...
Finance
  • OS_Pizza's avatar
    OS_Pizza
    2 years ago

    You can write to AdjInput using api.data.calculate. Below is the simple formula which i ran using custom calculate DM job.

     

    api.Data.Calculate("O#AdjInput:'all other filter'=O#Forms:'all other filter'")

     

    You can see the blue coloured cell which indicates calculated cell for AdjInput  member.

     

  • Mike_Sabourin's avatar
    Mike_Sabourin
    2 years ago

    You shouldn't have to specify AdjInput separately. Typically, for the items not specifically spelled out in the calculations, it will do the calc at all levels, meaning it should copy from Import, Forms, AdjInput, etc on its own.

Mike_Sabourin's avatar
Mike_Sabourin
Contributor II
2 years ago

You shouldn't have to specify AdjInput separately. Typically, for the items not specifically spelled out in the calculations, it will do the calc at all levels, meaning it should copy from Import, Forms, AdjInput, etc on its own.

  • Beeswing77's avatar
    Beeswing77
    New Contributor III
    2 years ago

    Thanks..  that's what I expected at first.  

    In the end, I worked out that someone had left a 'api.Data.ClearCalculatedData'  which was a bit too general,  and that was clearing my AdjInput data in the target scenario.   It wasn't Calculated Data in the source scenario, so was not getting cleared there.  Hence the mismatch.