关于Awhitworth

AWhitworth

I am encountering the same problem and thought I would resurrect this thread and see if anyone found a complete solution? I got to Jason's idea on my own before searching for a better way as this isn't ideal when we have to combine the rank with other lists and larger time ranges. in excel it's possible using a combination of If, Sum and Count in an array but this isn't possible in Anaplan.

AWhitworth · 11-17-2021

Agree with everyone above this is really needed, I'm currently using a field card in the additional insights as a workaround but it takes away from the experience.

AWhitworth · ‎10-21-2021

嗨，为此，您将需要使用读/写驱动程序，以下是指向Anapedia上动态单元访问的链接，该链接将概述其工作原理：https：//help.anaplan.com/d10ce953-9063-405f-B146-E7D5E55383E2-DYNAMIC-CELL-ACCESS

AWhitworth · ‎10-18-2021

Hi @hyudolee For me, it would depend on what other cards you have on the page, If you only wanted that one card locked to all use the card Context if it was multiple cards with the same requirement then the filter. In truth, I would probably end up doing both methods just to be certain.

AWhitworth · ‎10-18-2021

I would love to be proven wrong but it isn't possible to sort the line items, the order can be manually changed by right-clicking on one and selecting "select items to show" then saving that view or by reordering them completely by selecting Edit and reorder

AWhitworth · 08-10-2021

This is a nice way of doing it without using subsidiary views with Quarter and Year timescales.

AWhitworth · 08-10-2021

Does the list have a code that could be copied instead? If it is the type of list without any code your options would seem to be more limited.

AWhitworth · 07-20-2021

我同意Timesum是您最好的选择，因为它非常灵活，您可以在整个时间范围内进行时间，在这种情况下，您的公式将是时代（表A.Amount b），或者您可以在以后指定开始日期和结束日期金额B.这是指向Anapedis页面的链接，它显示了您可用的所有不同选项：https：//help.anaplan.com/en/13d8b551-4e13-413b-a39f-f25579d21e38

AWhitworth · ‎07-14-2021

This would be a useful enhancement, have you added the suggestion to the idea exchange?

AWhitworth · ‎07-14-2021

Yes you can do this, instead of publishing selected line items use the option publish page selectors to dashboard with the line items pivoted to the pages

AWhitworth · 07-07-2021

如果您的显示名称是文本格式的，则可以使用[查找：列表]引用此名称，该名称将通过文本格式带来显示名称。

AWhitworth · ‎07-01-2021

嗨，@gfraviseo，有几种方法可以这样做，如果您使用版本可以利用Anaplan中的切换功能来填充实际版本中的值，但可以手动输入预测版本。如您所提到的，这些都是所有订单项，我建议添加第三个订单项，该项目根据本月结合实际和R1订单项。该公式将引用时间段，并检查是否在预测开始日期之前，以及是否为真实值，请使用R1值。希望这可以帮助。

AWhitworth · ‎06-24-2021

I second the above replies, check with your tenant admin that you have "page Builder" access and ensure you aren't building as a personal page. This should fix your issue.

AWhitworth · ‎05-04-2021

我也没有意识到这也很快发布了，但是尝试了一下，我已经迷上了Ctrl+Shift+f。

AWhitworth · 03-23-2021

Agree with @Misbah, from experience if SSO is switched on you can log into a workspace but not see any models/pages unless set up on the workspace organisations SSO. If having everyone use SSO is a priority then they will need company SSO access, otherwise, leave them as exception users and limit access to only DEV models.

AWhitworth · 03-12-2021

之前我遇到过这个,也找到了import can completely fail if you have too many columns before the time months start. I don't remember finding an Anaplan solution but instead had to change the import file around, unfortunately.

AWhitworth · 03-09-2021

目前，我们可以在瀑布图表上抑制零，但是在其他图表（例如Pie＆Donut图表）上没有选择。我们可以应用一个过滤器排除零，但是为了保持一致性，最好在所有图表类型上选择选项。这也将使最终用户在不需要使用过滤器功能的情况下切换自己的页面。

AWhitworth · ‎02-19-2021

Hi @ShekharGite There are a few ways I would approach this and the best one probably depends on your use case and model set up. Apply selective access to the currency list so that the USD option is disabled for those who don't need to see it. The benefit of this is that it would apply across the whole model. Use a separate list with two items 'Local Currency' & 'Reporting Currency' for those countries which are EUR only it show as EUR for both but others could have EUR as reporting currency and USD as the local currency Have two sets of line items one for EUR and one for USD and use line item subset filtering to hide the irrelevant ones based on the country selected. This would work if users needed to see the values in the same view

AWhitworth · 02-11-2021

Hi, I don't believe you can do this using the import action but I would normally set up a second line item in the same module which references your imported data line item and changes the signage that way.

AWhitworth · 02-05-2021

I have just encountered this and agree it should be built into NUX. We can currently do it in classic so makes sense to also be available in NUX. To achieve this I am having to use a saved view, but then can't apply consistent conditional formatting with other modules on the page

AWhitworth · ‎01-25-2021

嗨，最基本的选项是，您可以每天手动运行此过程，并在对话框中选择最新的平面文件。但是，您可能需要研究Anaplan提供的许多集成选项。以下链接突出显示了您可用的不同选项，建议您研究Anaplan Connect。https://help.anaplan.com/en/f3ec5fcc-0e46-4a59-bcce-c1319716b823-data-integration

AWhitworth · ‎01-19-2021

同意100%, every other step required to set up a numbered list is completed in the List itself except assigning the Display name. Setting this on either the Properties of Configuration tab would make sense.

AWhitworth · ‎01-13-2021

也同意，即使表格可以自动填充当前上下文的父字段。这将减少用户输入，但允许他们在创建新项目之前检查

AWhitworth · ‎01-11-2021

我同意较早的评论，处理此实例的最佳方法是使用数据源中的字段创建一个唯一的ID。好消息是，您不需要在导入之前脱机，您可以指示Anaplan将这些字段结合在您的导入过程中

AWhitworth · 01-05-2021

It is possible you do not have Page Builder access, can you check with you tenant admin as they will be able to provide you with the correct permissions

AWhitworth · 01-04-2021

Hi, Lookups with versions in Anaplan can actually be quite tricky as you can't set a line item format to the native version list. If you are using a Version list it will be more straightforward. However if not don't worry this blog post should give you the steps you need to take: https://community.anaplan.com/t5/Best-Practices/Bridging-Versions-With-Waterfall-Charts/tac-p/94087#M677

AWhitworth · ‎12-23-2020

Great write up on what can definitely be a difficult report to build. I believe the inability to format a line item with Native Versions is the biggest drawback to using native versions currently. Unless there is a requirement to use the native versions I would always look to use a list for versions as it gives so much more flexibility without any real downsides.

AWhitworth · ‎12-23-2020

Hi, You'll need to make use of AND OR to account for both scenarios with a formula along the lines of: END() > Effective from AND ( END() <= Effective To OR ISBLANK(Effective To) ) This is using the last day of the month to check but you can customize it as needed for your scenario, and don't forget to use a system module for you END() and replace that in the formula above

AWhitworth · 12-21-2020

You could use that start date and period() function to find which month satisfies the 92 days prior. using a month period line item your formula would be Period(start() - test doh) from here you should easily be able to calculate how many months to look back.

AWhitworth · ‎12-20-2020

Hi Jared, Could you send me the info too, please? Thanks, Aaron