2.3.10 activity

I need help, I’ve been on this section for a couple of days and can’t seem to figure out why my data is not populating. My formulas are correct but I’m not understanding.

AA023F09-599F-4204-869F-02F7C079465F.jpeg

E0C930A1-DB53-49EF-A016-5C9B47374799.jpeg

 

 

Answers

  • Hi

    It seems your DAT03 Historic volumes data does not have data for all weeks. Can you check.

    Thanks,
    Manjunath

  • Check for Baseline Forecast Line Item, the modules used in the logic (i.e., Date03....) check are they populated?
  • Hello, 

     

    yes all of my data is in DAT03. I think I just figured it out. My data for SYS09 vanish but I can’t figure out what section that came from. 

    4159BBFF-4AFE-401A-A8F9-2E938B932ABB.jpeg

    EA5E4D5E-AF0E-480E-BD99-F8C5C97FA448.jpeg

  • Hello, 

     

    Yes all of my data is in DAT03. I think I just figured it out. My data for SYS09 vanish but I can’t figure out what section that came from. 

    1F9491F6-009D-4E83-BB06-C81E2536189D.jpeg

    6D2715E4-439D-4E5B-A322-269730E3F1B4.jpeg

  • Hi,

    From above blueprint view, one can understand that all the four linetems are based on one Baseline Forecast, we can see if you show the clear screenshot(use sipping tool) view of blueprint of your DEM03 or the logic for baseline forecast would do fine 🙂

  • Here’s my baseline.. 

     

    071CB346-C455-440E-A242-76B66C7BCAAD.jpeg

  • hi
    can you show sys01 module. because your baseline forecast line item is applied by if else logic. 

    so by your output you see, it means that your current week is first week in your sys01 module.

    Thanks

  • Hey here’s my SYS01,  I’m not sure if you wanted the blueprint version or not so I took both. 

    B1A05BAF-9C2E-48A3-AC6B-2B834D6C5FC1.jpeg

    405DA670-11CA-4BBC-B094-FDCA04F716E3.jpeg

  • hi,

    your value in baseline is correct. you are getting the data for current period only(you can see 1st week is ticked).

    Thanks

  • Okay, but why isn’t the rest of my data showing?

  • Because your formula is coded like that.

    Change the code of current period line item to ITEM(time) to see all months data, but kindly put back your old formula after testing.

    Thanks

  • So I’m deleting =Time.’current period’ and just keeping ITEM(Time)?

     

  • yes, and put back the old formula after testing. 

  • Item(time) doesn’t go through without the complete formula. 

  • for me the SYS01 CurrentPeriod? is  ITEM(Time) = TIME.'Current Period' and your DATA03 looks fine

  • IS this your logic for Baseline Forecast? please check,
    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)