2.3.10 Activity: Create Demand Forecast

ademmagatur15
ademmagatur15
in Academy Discussions

I have aplied formulas but results are not correct. Please advice

Here are screenshots

TinyTake18-03-2023-08-57-57.png
TinyTake18-03-2023-08-59-03.png
TinyTake18-03-2023-08-59-31.png
TinyTake18-03-2023-08-59-49.png
TinyTake18-03-2023-09-00-10.png

Answers

  • AjayM
    AjayM

    Hi @ademmagatur15 ,

    Growth rate is to be applied over and above the baseline forecast, not within that. In other words, if growth rate is 5%, the default forecast should rise up to 105% (that's 5% beyond baseline).

    Hope this helps.

    Cheers!

  • ademmagatur15
    ademmagatur15

    Got it thank you!

  • VIVIANMO
    VIVIANMO

    Hello, I HAVE TROUBLE in the formula, can someone help me? Thanks

    截屏2023-12-05 00.01.16.png
    截屏2023-12-05 00.03.26.png

  • rchaudhry
    rchaudhry

    hi ademmagatur15

    i am stuck at the baseline forecast formula.can you help me?

  • DineshSeeram
    DineshSeeram

    IF    'SYS01 Time Settings By Week'.'1st Forecast Year?'THEN    'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'ELSE    OFFSET(Default Forecast, -52, 0)

  • DineshSeeram
    DineshSeeram

    I finally figured out with

    2.3.10 Activity: Create Demand Forecast.

    I can help.

  • DineshSeeram
    DineshSeeram

    This is the correct formula for base line forecast.

    IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'

Categories