Unable to link two modules to aggregate the data

Need help in resolving this issue. I am having two modules, Comp Onhand Inventory and Comp Demand Analysis.

Comp Onhand Inventory holds onhand inventory information for Items in each organisation. Each item is assigned to a configuration.I am trying to aggregate the onhand information by Organisation and Configuration in the module Comp Demand Analysis.But,I am not getting the value showing up in the Comp Demand Analysis module. I have attached the screen shots with this.

can you help me to find out what is missing here?

Thanks

Regards

Prabakaran

com;_demand_analysis_data_76461.png

Comp_onhand_inventory_setup_76461.png

Comp_onhand_inventory_data_76461.png

Comp_demand_analysis_setup_76461.png

Accepted answers

Constantin

Hi @praba71,

I hope you are doing fine! I just replicated at a small scale what you want to do and it works just fine (images attached to this message). Can you have a quick look at my simplified model and try identify the issue in your calculation? This was based on your initial calculation. Please let us know your thoughts on it.

Hope this helps!

Kind regards,

Costa

Regular_view_76715.PNG

Blueprint_mode_76715.PNG

Constantin

Glad to hear that!

I wish you all the best with your build.

All comments

Misbah

@praba71

Formula looks good. Can you please check one intersection if the numbers are flowing. BF1 and FLRHDD - disk. Right now I don't see that intersection in the module instead it is BF1 and some RAM combo intersection.

praba71

Hi @Misbah thanks for the response. Please see the screenshots attached. FLRHDD0002 has onhand qty in Comp Onhand Inventory module. but showing zero in Comp Demand Analysis module..

Thanks

Regards

Prabakaran

Screenshot_2020-07-09_at_4_76476.png

Misbah

@praba71

That's weird. I think there is nothing wrong from your end, I would suggest you to raise a support ticket on this and share the feedback with us.

praba71

Hi @Misbah

I had to change the formula to accommodate a change in requirement. Please see attached the new setups. But, still I am not getting the qty aggregated in the comp demand analysis module. Do you see any issue in my new setups?

Thanks

Regards

Prabakaran

Screenshot_2020-07-10_at_3_76573.png

Misbah

@praba71

We checked it yesterday. Even this looks good, kindly check one more time by filtering on non zeros. If you don't see any data better to log a ticket with Anaplan support support@anaplan.com

Constantin

Hi @praba71,

Hope this helps!

Kind regards,

Costa

Regular_view_76715.PNG

Blueprint_mode_76715.PNG

praba71

Thanks @Constantin for the details.. It worked for me..

Constantin

Glad to hear that!

I wish you all the best with your build.

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