Unable to link two modules to aggregate the data

[praba71]

Hi 

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

[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

[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

[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 · Accepted solution]

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

[praba71]

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

[Constantin · Accepted solution]

Glad to hear that!

I wish you all the best with your build.