Top-Up current period value to specific period

Atz1234
edited December 2024 in Modeling

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

Best Answer

  • Dikshant
    Answer ✓

    Here is the solution

    image.png

    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)

Answers