Hi, I am struggling with updating the formulas of Confirmed PO Delivery and Confirmed Purchase order receipt. Regarding "Confirmed PO Delivery", I understand to replace OFFSET by POST, to push the dat…
I'm unsure of where I am going wrong. The task here is to populate the missing Regions columns with the parent line item from the 'Countries' file. I am mapping the following; column 2: country name t…
I would like to have the possibility to define the date format for exports to cloud storages. When you currently export files through Cloudworks you have the choice to tick/untick the overwrite file o…
Hi Everyone, I have line items which is the concatenated string ex - 123,435,234,678,567,987 I would like to find no of strings present ie 6 Could you please help me with this. Thanks Tejaswini
* Hi, in a module saved view, I created a grid with weekly time buckets filtered on about two years history and two years future.. On the NUX dashboard view, the grid starts from the first week, so 10…
I would like to have a unique identifier for every line item in a blueprint displayed either on screen or when I do an export as this will enable me to do more straightforward comparisons between mode…
Having a Roles list that is auto-generated and able to be leveraged in modules would be very helpful. For example, in certain system/admin modules we assign read/write drivers on partiucular line item…
Hi, I checked the answers related to this topic but I couldn't find the answers. In the DEM03 Demand Forecast module, I have the Baseline forecast values for FY20 which is coming DAT03 Historic Volume…
The average summary method and aggregation function [Average:] both include zero values when calculating an average. This makes sense but sadly means that in almost all scenarios the irritating workar…
I would like the ability to more easily step through the actions in a given Process. Often when trying to debug an issue with a given process, I need to step through the actions in the process to see …
Hello, My model consists of hierarchical lists, E1 Expense category, E2 Expenses. I created an input module with E2 expenses, time(months), Money spent (line item) as dimensions. I have applied filter…
Hi, Need to know how to get a date to show for a line item that is dimensioned by time, but the module is not dimensioned by time. The formula is working correctly, but can only see the result in a su…
Exciting news on the new calculation engine. I saw the memory consumption on data https://help.anaplan.com/616ee341-8a5f-4718-8c90-c82e34eca86c-Understand-sparsity-and-density , however how do calcula…
I would like to apply the DISCO-methodology to the Model Map. The most efficient way would be to label the Functional Areas to the DISCO. The model map could then be visually sequenced based on the DI…
Hi, I want to use List Subset. We can import Boolean item to List Subset. But we can not input the formula in List Subset and can not make a refference in module. How can I manage it in module and Lis…
Throughout my five-plus years at Anaplan the conventional wisdom has been that we should eliminate sparsity in order to model efficiently. Throughout the last year, as part of the PLANS standards init…
Hi. Currently the Retention (B8) field is returning the sum of all values. I've introduced a boolean field but i'm unsure how to update the formula so that it only returns the value we want (which is …
Hi, Currently I'm trying to make it so if a end user puts in a number from a inputs model I created, then it will override whatever is there in the current month. The formula below is what I created s…
Gurus, In some line item, currency will be different and depends on company to be selected. For example, if subsidiary is Japanese company, currency will be JPY which is no decimal point, And if subsi…
Hi, currently have a process that is supposed to take data from one module and put it into another. But currently the process is not working. Screen shots of error are below. Thank you
Hello. Please help me for settings of exports. I've changed many variants, but it still wrong. The pivot Filter - Months Only Summarize - none I try to export grid or table, but it gives mistake for i…
Nithyashree nithyashree@matasma.com. Hi, I have taken two attempts in the level 2 sprint 3 exams. And all the other attempts are loaded with the same score as in the second attempt. Suggest me any ide…
Overview The scope of the solution is aligned among the project sponsor, key stakeholders, and the architect. The solution addresses all the concerns of the current business process and will drive the…
Hi! Is there a boolean line item to add to SYS01 so it only shows the first 1-5 weeks in the SYS01 module? it's annoying to see 100 weeks when all I need to see is 10 or so
Hello fellow Anaplanners! I have a scenario that is captured exactly in the following Idea Exchange and I'm certain you all have or will need this in the future!! The scenario is essentially to have a…
Hello, can you help me for find mistakes: 1. Begining inventory 2. And wrong result for shipping time weeks = 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Produc…
It will be helpful to have selective access to timescale as well as there are different people looking into historical data and projection data. We don't want to show projection months data to people.…
Hi - Please could you help me tidy this forumla so that its accepted by Anaplan? IF Type = Supplier Type.Purchase Order (IF 'Forecasted total Value £ (E)' - 'Supplier PO Value (B4)' > 0 THEN 0 ELSE 'F…
