Modeling

Filter Full Year
i want to ask, i have module like this the module have 2 lines item actual and budget for the display i used filter for this, but the problems is in the full year the line item is actual, i want to change to bottom up amount, so if on the FY 21 have actual and bottom up amount FY is Bottom up amount and if FY 21 is actual…
How to show summary levels dynamically for automatic update of chart
Hi, I have a module with time and client list as dimensions. The client list looks something like this: Economy Clients - Economy Client 1 - Economy Client 2 Premium Clients - Premium Client 1 - Premium Client 2 The line item, for example, is Revenue. I published the line item as a chart by manually selecting only the…
Chart in Anaplan Dashboard
Hi team, There is one Numbered List(Site List) and a Line Item(WFC). And we need a Chart(Dot Chart) with WFC >6 and WFC <6 in different colors. Can you please help me on this. Thanks
Search in Select source
Please add the option to search from "select and existing source" while defining and import. Currently, we need to scroll up and down and it is tedious if the list is big.
REV03 Margin Calculation
Hello, How can I please, desincrement my (Renenues-Cost of sales and margin ) I just wanted to test this , unfurnately, everything is changed. Hello, how can I desincrement this?
Failed Order List Action
I have a Order List action that works great in Dev, but fails in test. No error message - Just Failed Action Message. Detail reveals: The model and Workspace ID are the same as the Model where the action resides
Enhancement to RANK function when dealing with tied rankings
It would be really useful for certain cases if the RANK function could generate a sequential output when dealing with tied data. Currently, the RANK function can deal with tied entries in 4 ways, MAXIMUM, MINIMUM, AVERAGE and SEQUENTIAL and all handle tied data in a slightly different way but do not generate an output in…
MAKELINK Embedding Issue
Hello, I am trying to embed a MAKELINK formula within a list, however the list item I want to embed the MAKELINK into is a function of a LOOKUP, and therefore I am struggling with how to format the MAKELINK. See below: The current List Item title is "Item Name." The current formula for "Item Name" within the list…
Establishing Sales Targets Business Process Questions
Generally Business planning starts in last quarter of current year for Annual Budget, how the actuals are handled for last quarter. Is it manually forecasted, copied from last quarter, copied from Previous year Last quarter , copied from Current year Budget?
In NUX on worksheets, the ability to publish rollup levels as context selectors
On worksheets within the NUX, there is currently no ability to publish rollup levels only as context selectors and synchronize. In old UX, you could publish any list as a context selector and then synchronize on selection, so that allowed you to sync with any level in the hierarchy. The workaround currently is publish…
ifrs 16 lease modification
Hi, I'm building a model to capture and plan leases against the IFRS16 standard. I use a numbered list and have a form to capture start date, end date, initial payments, fixed payments and discount rate. The output is a report by lease showing Interest, Depreciation, Lease Liability. We need the function to modify the…
Trying to load from file to module data
Hi Community, I'am developed following dashboard to our end user. My problem is that if I want to load local accounts from a file - all local account will goes ignored state. The module contains a numbered list. My primary key in the module is combination of company+local account number. My question is that how can I…
Collect () function with multiple/varying formats
The Collect() function is great for collecting values, however; becomes problematic when trying to bring in a combination of numbers and percentages, and impossible when trying to bring in text or list items. It would be great if the collect formula could follow the same formatting as the source module (i.e. no need to set…
Additional Argument for TimeSum
I would like Anaplan to add a new optional parameters for Timesum. The formula would look like this, TIMESUM(x, [f] , [t], [a], [at], [ar]) wherein * [at] stands for aggregation type (simple, year on year). If omitted, default to simple * [ar] is the resulting value in absolute amount or percentage growth. If omitted,…
How to count in which number a particular date will come
Hi all, I have a module in which a line item is date formatted and need to find in which week the dates will come as i have to calculate weekly average for all the weeks of a year. Please suggest how to achieve this. Thanks
Only column headings to remain without showing period totals
Hi I'm a beginner in Anaplan and need some advise on how to retain just the column heading for a time period say Jan 19 without sub-totals showing for each line item. The sub-totals should be blank. I tried playing around with Summary Methods in Blueprint mode. I could turn off the column entirely by selecting None for…
'SYS08 Employee Details'.Region
I'm having a little difficulty in the exam on activity 6. I understand the sum that needs to be completed on region and role, however I am having difficulty updating the region on the SYS08. Am I going down the wrong path or how should I think about updating this region in the module? Thanks,
Child with several parents in hierarchy
Hi all, I would like to create a hierarchy with 3 levels of lists: 1. Entity > 2. Direction > 3. Department. In the level "2. Direction", I want items to belong to several Entities. It is the same for Department level (a Department can belong to several Directions). I need to create a data hub and then a spoke model. In…
Create two lists from one existing list
Hi Team we have a list with list items as 20180101,20180101.01,20180101.02. Now I need to create two different lists as parent child hierarchy from existing list. If ".01" is there at right hand side(20180101.01) then it should reflect as "Branch1", If ".02" is there at right hand side(20180101.02) then it should reflect…
Getting Invalid date format while data import into module
hi, my source file contain time in format 201901 201902.. etc as line item. while importing i am getting error as above . which time format i have to select.? adding source file below. please help to resolve the error. Thanks Jerin
List and Modules
I am Working on a Test Module dimensioned with List B which is child of list A; There are some list items in List A which doesn't have any child. In Test Module I have created two Boolean which 1)checks child is present 2) parent with no child and I have created 3rd Boolean which will be true when 1 or 2 is true, but I am…
Taking an average of specific Quarters, like all Q1 or all Q2 over many years
Hi, I'm attempting to generate some historical trends to drive future projections. In doing so, I have % Weekly over a 13-week period (one quarter), and I have this over many quarters. I'm trying to capture an average of all Q1 % weekly values (such as FY18 Q1, FY19 Q1, FY20 Q1, etc.), to predict a likely quarter…
Adjust Column Widths in Blueprint Mode
Being able to adjust column widths in Blueprint mode would be great. Rather than having to open an 'Applies to' menu, format menu, or copy and paste notes, and formula references, it would be great to adjust column widths in the blueprint mode. Alternatively, it would be helpful to have a "view" window or cell (similar to…
User filters and Top levels
Hi, I want to set up user filtering for a module, with Customer and sub-brand, I have a user filter module, and system module with the appropriate line items I use the system module as a filter and this all works as expected. I want to be able to choose a specific customer and a specific brand or a specific customer…
Archive - Filing System
Can the ability to add folders into archive be created to enable organised archiving of models, as a user of a live model often prior to making changes a version is archived should we need to revert this makes it extremely difficult to find the latest archived model.
Logic Line item availble two function (Input and Formula)
Hi, Everyone. I have a question about logic Anaplan, I have a module that will create an item that can contain input and formulas, for example, for example, a period that is less than the period parameter will be blue font or input by the user and more than the period parameter will take a logic formula. Has there been a…
Item deleted from List
I have accidently deleted an item from a List in a Module. So the item still exists in the List but not anymore in the Module in which that List has been used as a Dimension. Any clue how I can get the item back as a part of the List in the Module? thanks.
Let end user add multiple items to a list
Hello, The organizational list of my business in Anaplan need to be updated every week, because there is a lot of new client. One end-user need to have the possibility to add several items in the same time in this list. I created a form to let this user add item to the list but the user can only add one item , and this…
Please improve The function of data export from module Line items blue print view (*Format, Summary)
Dear Team The function of data export from module Line items blue print view is very useful for understanding the model especially in case there are many modules in it. But I found that the important items aren't exported in understandable format, those are "Format" and "Summary" column. Below is the example of format and…
Backlog and Lead times
Hi, I need to calculate a backlog for per product per day. I have a module with Factory open days and closed days and a module with lead times by product. Volume gets sent to production (factory) and then I need to take a lead time calc for the products. The trick is that to work out how many future days in a row the…

Modeling

Discussion List