2.3.10 activity

Dijones128

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.

 

 

 

 

 

ManjunathKN

Hi

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

Thanks,
Manjunath

sobaid

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

Dijones128

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. 

 

 

Dijones128

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. 

 

 

sobaid

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 🙂

Dijones128

Here’s my baseline.. 

 

 

ManjunathKN

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

Dijones128

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

 

 

ManjunathKN

hi,

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

Thanks

Dijones128

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

ManjunathKN

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

Dijones128

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

 

ManjunathKN

yes, and put back the old formula after testing. 

Dijones128

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

sobaid

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

sobaid

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)