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

Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…