get inventory per country per sku

I have an Invenotry ordering module where i have beginnening inventory, i want to get the inventory in a new moudule by country and by country and sku both i have a sku details module which has country made in as lst item and sku as a dimension

i tried using this formula but got no data
'INV01 Inventory Ordering'.Beginning Inventory[SUM: 'SYS08 SKU Details'.Country Made In] for inventiry by country

Accepted answers

AjayM

Got it, thanks for sharing.
Looks like you don't have (or don't need) time dimension in INV05 and INV06 modules?
If you don't need time dimension in these modules, you need to make sure your formula takes care of aggregating values across time dimension as well from the source.

First verify if 'Total of All periods' is turned on under model's time settings ('Include' section at the end).
If it is turned OFF, you can use TIMESUM function in your formula.
If 'total of all periods' is turned ON, you could instead use the select function like "select:time.all periods" in the formula.

If you need time dimension in INV05 and INV06 modules, just enable it, and your original formula from first post should work.

Cheers!

Prajjwal88

Hi @Abhishek586 ,

I agree with the solution mentioned by Ajay, The other way to do this is you can simply make another line item in your source module INV01 for beginning inventory say 'beginning inventory TimeSum' then just mark the same Line Item's time scale as Not Applicable from blue print view and apply the formula as-
TIMESUM(Beginning Inventory)
And after that you can simply use this Line Item instead of previous one in the target module with the same formula you have applied already.

I hope it helps.

All comments

AjayM

Hi @Abhishek586 ,

If your source module INV01 is already by SKU, why do you need a summary in another module also by SKU (besides country)?
Check the summary setting of 'beginning inventory' in INV01. I see time summary is ON, but the normal summary?

Cheers!

Abhishek586

hi @AjayM

i need it like this

and inventory by per country per sku

the normal summary is sum and the time summary is opening balance

AjayM

In both these INV modules, same formula should work - the formula that you mentioned in the original post. Mind sharing the snapshot of INV05 module result after applying the formula?

Abhishek586

sure here is the snapshot after applying the formula, no data is seen
however when i use data01 module to get the inventory the data is displayed

here is my data 01 module

AjayM

Cheers!

Prajjwal88

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385