Level 2 Sprint 3 126.96.36.199 Create Distribution Center Capacity Module
Hi! I am having issues with the formula for Total Beginning Inventory in INV04 Distribution Center Capacity.
The formula I have used is 'INV01 Inventory Ordering'.Beginning Inventory[SUM: 'SYS08 SKU Details'.Distribution Center] but it only returns zeros instead of the correct amounts. Any idea why would this happen please? Attached some screenshots.
I just can't figure out why it's not working. Thank you!
The summary type for Begining Inventory in INV01 - I set this to None as required in the training instructions. I changed this now for testing purposes to "Closing Balance" but this still doesn't seem to solve the issue in INV04.
Regarding the WEEKVALUE() function. My source model is at week level but the target is at month level. Shouldn't this then be automatically aggregated by Anaplan without me using weekvalue?
Re: Level 2 Sprint 3 188.8.131.52 Create Distribution Center Capacity Module
Ok, so I just built it from scratch, same formula, same summary method for the source model (None) and this time it worked...still no idea why I got zeros in the first place. But glad it works. Thanks!