Top-Up current period value to specific period

Hello everyone, I would like to know if it is possible to top-up the value of the current period to a specific future period. For example, in my Forecast dimension, I have a value of 1,500 for the November 2024 period and 3,500 for the December 2024 period.

{BFA601BD-6616-4BC5-9678-11AF6AA627F1}.png

My objective is to top up my November 2024 value to the December 2024 period using my sys control module. the result for nov 2024 will 0 and dece 2024 will 5,000.

{C5D0D053-F097-403A-858F-33546679179F}.png

{94349EF5-6B8C-447F-A41F-A2C4512A5A05}.png

and the result will be reflected in the Forecast Report module under the Reporting dimension.

{084D3912-52D0-490D-8A1E-7C539EA58675}.png

Accepted answers

Dikshant

Here is the solution

Offset Period: IF ISNOTBLANK(Date Period TO) THEN MONTH(Date Period TO) - MONTH(Date Period FROM) ELSE 0

Final: IF Offset Period <> 0 THEN Forecasted Value ELSE POST(Forecasted Value, Offset Period)

All comments

pyrypeura

Hi,

I think what you describe would be possible using POST function of Anaplan.

Dikshant

Here is the solution

Offset Period: IF ISNOTBLANK(Date Period TO) THEN MONTH(Date Period TO) - MONTH(Date Period FROM) ELSE 0

Final: IF Offset Period <> 0 THEN Forecasted Value ELSE POST(Forecasted Value, Offset Period)

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…