About zaibhamid81

Hi everyone, I am on L2 Conclusion chapter. I have created the formula to populate Shipping cost. Please see below formula . As long as I understand the formula is correct but the aggregation i am getting is not correct. 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] Plesase see the result of this formula. The values are very high. Actually this formula is aggregating the shipping cost from weeks. but in most of the months only 1 week have shipping cost but this formula is applying the same cost to each week and giving the aggregation. See below screenshot of the source module. In jan the cost of shipping is 532.6 but with this formula I am getting 532.6 x by each week even though there are no values in those cells. Is there something wrong with formula. Any help will be appreciated. The below has been asked in the activity. ... View more

大家好，您能解释一下何时使用查找或总和功能，我记得MB 1级课程中有一个课程，但我找不到它。如果有人可以提供课程的链接或解释使用何时使用的学期差异，我将非常感谢。JH ... View more

Hi Everyone, Could someone please explain this formula in layman's language. OFFSET(1, -1, 0) = 0 Thanks JH ... View more

大家好，在将公式放入Sprint 3之后，我会遇到匹配的工作。所有价值都是匹配的，但摘要总数在SKU级别和所有产品级别都不匹配。请告知我做错了什么以及如何解决这些问题。请参阅我的模型的屏幕截图。SKU级别所有产品级别都要提前。JH ... View more

大家好,你能帮我一个竞争ctivity 3.3.5.2. I am struggling with the missing formulas in the screen shot. I will really appreciate if someone can help to resolve these formulas. Also please let me know if all other formulas are correct.   Thanks JH ... View more

Hi All, I am at the end of MB L2 Sprint 2 and working on the few last actives. Having some issue with 2.4.11.2 Create Account Demand Manager Role activity. Please answer below questions. 1. Why do we need to provide read access to SYS00 time module ( without providing access to roles to this module, the line chart is not visible on the UX page) 2. I am unable to figure out settings for Account Demand manager to update field card on the UX page. Edit only their assigned customer accounts. View the information for other customer accounts. Any help will be appreciated. JH ... View more

Hi All, As the title explains the issue, I am unable to see the check boxes in my grid view for a boolean formatted line item, can someone please help and identify what am I missing ? Please see the screen shots     Any help will be appreciated. Thanks JH ... View more

嗨，我位于2级MB的Sprint 2中间，但是我看不到在我的应用页面上创建应用程序的任何链接。我是否必须要求许可，还是我们可以在免费的训练中获得免费的跟踪日志帐户。谢谢 ... View more

大家好，我无法理解Anaplan是如何使用数据引用的。请参阅以下方案。我必须创建一个带有产品SKU详细信息的系统模块。我将SKU平面列表用作维度和代码，产品和配送中心作为订单项。我已经从CSV文件中导入数据，看起来像这样。 The below is the blue print for this module.  As you can see I have used product flat list , and Location flat list as format for these line items (code as text). My question is that how come Anaplan has reference location flat list in my module and generated the exact location names , when the CSV file only had location codes only not the names. Please see the data mapping image below for the .CSV file.  Also see the screenshot of the Location Flat list. there is no Code information loaded in it. I cannot understand how Anaplan know which code is related to which location name when there is not link between them.   Also I have another question that why do I have to use a formula for the code line item in this scenario when I already have this code information generated through the .csv file please see the first shared screen-short. I am referring from lesson 1.4.3.2 from Sprint 1 Level 2. as it is a part of the activity. see the below image of the activity. I also don't know how to reference this code formula as I dont have codes in my flat lists.   I will appreciate if someone can provide this information. thanks JH ... View more

Hi Everyone, Could someone please advise how to map this data in L1 MB activity 8.5.3. Please see the screenshot, I have tried time with Column header and then mapping time values manually in the time tab but it fails to map all values ( 36 values failed) Many thanks in advance. ... View more

Hi Everyone, I am stuck at 7.2.3 Activity: Import Data into Employee Details Module. The instructions are not clear how to map E2 Employee# list ,which is a numbered list, to the .CSV file. There is Hint in the lesson which clearly says this: HINT: The E2 Employees# list is a numbered list and each record is assigned a unique identifier. When mapping the data, you should not map by name or map manually. This means that I cannot map data against names and also not by mapping manually but i cannot find any other option. Please see the below screenshots.   Any help will be appreciated. Thanks Zeb ... View more