关于fabien.junod

大家好，我是唯一对新蓝图视图感到惊讶的人（列的顺序已经改变），无法找到有关Anaplan社区的任何信息？    ... 查看更多

你好所有的,我用它的建议公式te the # of weekdays between 2 dates https://help.anaplan.com/21bf8e70-3193-4912-98c6-f25327c11d19-Excel-Equivalent-Formulas and I noticed many errors when the end date was a monday (see attachment). Has anyone else also noticed that? Also, I would like to propose a different formula (with the same line items) Start Date End Date # of working days = ROUND((End Date - Start Date + 1) / 7, 0, DOWN) * 5 + MOD(End Date - Start Date + 1, 7) - IF MOD(End Date - Start Date + 1, 7) = 0 THEN 0 ELSE IF WEEKDAY(Start Date) = 7 OR WEEKDAY(Start Date) < 7 AND WEEKDAY(Start Date) + MOD(End Date - Start Date + 1, 7) = 7 THEN 1 ELSE IF WEEKDAY(Start Date) < 7 AND WEEKDAY(Start Date) + MOD(End Date - Start Date + 1, 7) > 7 THEN 2 ELSE 0 If needed, "- Holidays" can be added at the end ... 查看更多

Hello All, I have documented some discrepancies in the names of the line items throughout the Level 2 Sprint 3. I am surprised this hasn't been flagged (maybe I missed it) and fixed already because it has a direct impact on the exam. In the attached document, I am providing some advice on renaming some of the line items created so that the formulas are correct in the exam. Hope this helps. ... 查看更多

阿纳普兰（Anaplan）中列表子集的订购一直是我的谜，就像一种阿纳普兰（Anaplan）以神秘的方式表现出来。我一直以为 - 我是谁质疑我们心爱的平台在云中的内部运作方式？在本文中，我将讨论组织子集的主题。如果您像我这样工作，通过临时和持续添加列表子集，适应不断变化的需求并利用Anaplan List Subset功能，那么您在打开“适用”时可能会经历相同的惊讶这个地方。您可能会发现自己问 - 这里发生了什么？如果您不知道我指的是什么，这里只有4个列表和9个子集。当您创建一个新的模块并需要选择尺寸时，每个列表的子集将出现在主列表下。但是，当您在蓝图中单击“适用”（或在模块列表中）时，视图是不同的。这可能是混乱的。 You can imagine that with a growing number of lists and subsets, one can get lost. Methodology Here is a tip I use to tidy up the list subsets. 1. Every time I add a new list, I immediately create two dummy subsets > List X: START and >List X: END 2. Then, whenever I add subsets to that list, I do it between these two. In general, I add the new subset before >List X: END. But adding it after >List X: START, also works. 3. That's it...almost! Creating the Lists This method works best when the lists are added from bottom to top. Continuing with my illustration above, if I add the lists in this order: List D, List C, List B, List A, I end up with a clean grouping of subsets, appearing in the same order as the lists. If I create the lists in the opposite order: List A, List B, List C, and List D (as most people would), I end up with the list subsets in the opposite order. This is not a concern, as I still know where to find them. If I add new lists between existing lists, then the order will be mixed up, but at least I will have all the subsets of a given list grouped together. We cannot completely demystify Anaplan inner workings; we need a part of mystery to keep us on our toes! ... 查看更多