nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

All comments

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)

Quick Links

Can you help?

Unanswered questions

Anaplan Workflow - Failed Action when Triggering Workflow from UX
Hi, I'm trying to trigger a workflow template from UX as an end user and it fails See below The context: I've got my hands on Anaplan Workflow and testing some stuffs and it's suitability on our existing business processes. We already have a Price approval process configured as a custom workflow driven by booleans and…
Reverse Lookup for a List to List Mapping (more than one mapping)
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…