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; } } }

Need Help on Line Item Formula Total Beginning Inventory

neg177

Hi,

Need help with Formula. I have the following below. Please advice.

'INV01 Inventory Ordering'.Beginning Inventory[LOOKUP:'SYS07 Distribution Center Details'.Region]

Thank you

Accepted answers

jake_cosenza_1

Hey There --

Is there a time dimension to this module? Do you need to also sum up items by region or lookup? Could you post a screenshot of the formula/module?

einas.ibrahim

Hey @neg177

I’m glad you arrived at the right solution. That is always my goal, to help you understand the issue better so you can resolve it yourself.
If you still have any questions about a concept or a function, let us know.

also, please mark any response that helped you better arrive at the answer as an "Accepted Solution" so others have an easier time when seeking help through the threads.

All comments

jake_cosenza_1

Hey There --

Is there a time dimension to this module? Do you need to also sum up items by region or lookup? Could you post a screenshot of the formula/module?

einas.ibrahim

Hey @neg177

I assume you are working on Level 2 training.
it would be helpful if you provide some context. This way we can help you faster.

now, you are trying to calculate the Beginning inventory Line Item in the INV01 module or another module?
I assume another module, in this case you have to look at your target module -where you are writing the formula- and compare the dimensions to that of the source module -INV01.
if I remember correctly, you need to “sum up” the Inventory from the INV01.

Reviewing the dimensions will help you.

neg177

I believe I figured it out. I used the formula below. Please let me know if I'm correct.

Thank you

'INV01 Inventory Ordering'.Beginning Inventory[SUM: 'SYS08 SKU Details'.Distribution Center]

einas.ibrahim

Hey @neg177

also, please mark any response that helped you better arrive at the answer as an "Accepted Solution" so others have an easier time when seeking help through the threads.

neg177

great thank you so much, will do.

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
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…