-
How to shift an item in line items
Hey, is it possible to get a value from column 1 to column 2, from column 2 to column 3 etc for Base Revenue. I would like to calculate base revenue for columns 2,3,4 etc. based on 1 column, but I don't know how to get the value from the previous column. The target formula would look like this: IF VALUE(NAME(ITEM('Number…
-
Format of mapping used for lookup doesn't match any dimension of the source
Hello, I can't understand why I keep getting this error. I am trying to bring in Keeper 1 from the source module that is dimensioned by player, but the line item is an "owner" list line item. My target module is dimensioned by Owner with the line item as a "Player" list line item. See Screen shots below, what am I…
-
is there a way to show/hide line item based on a selection by the user
i tried using line item subset but did not know how to procced next
-
How to Disable a Parent Filter When a Child Filter is Selected, and Vice Versa?
Hello Anaplanners, I'm working on a filter setup where Category is the parent of Task in a hierarchy. I need help implementing the following logic: The Category Filters should be disabled when any of the Task Filters are selected. The Task Filters should be available when none of the Category Filters are selected. If a…
-
Level 3 - 5.5 Model Build Specifications
While Building Import process from the Data hub, I an getting confused should I import Sales Reps Flat# or G3S Sales Rep# in first Action of Build Sales Rep ? 5.5.2 Sales Planning Model - Import Processes Next, create import processes in the Sales Planning model to: Build Sales Reps Build Sales Rep Details Build Sales Role
-
3.3.5.2 Inventory Ordering Module Formulas
I'm really confused as to why my figures won't populate when I toggle from blueprint view . Here are my formulas. Someone please help.
-
3.3.5.4 Update INV01 Inventory Ordering to Allow Override of Order Amount
Is this the correct formula? If not, please help.
-
Why are there items appearing in the source mapping of an action that are not present in the LIS
Why are there items appearing in the source mapping of an already existing import action that are not present in the Line Item Subset? I have updated the LIS and still in source mapping I can see items which are not present in the LIS.
-
what are the challenges while building a model in FPNA
-
I'm really confused as to why my figures won't populate.
Here are the formulas I am using but when I toggle from blueprint view there's nothing there. Please help!
-
What are the best practices which we implement in Data hub
-
Multiple Model Dashboard
Hello! I am trying to create a Dashboard which has 3 different data source MODELS. I am creating the grid view as per different models, e.g. 1,2,3. Though each has its own MODEL data as per filter, when filter is set to first model 1,3 shows the same model data while 2 shows blank(as it should). How to make 3 work the same…
-
Enable Completion Task DCA on Workflow
Hi, I'm building Workflows and am using Decision Tasks as they are most efficient for my Business needs. I don't seem to be able to identify anywhere to set 'Enable Completion Task' DCA's on my actions in these specific types of task. Is there something that I'm missing? Sean
-
How to find the 12 digit Users code?
Hi fellow Anaplanners, Does anyone have insights on how to find this 12 digit code for Users? Apparently I need this code to bulk import users (Due to Selective Access for Sales Team) into my model. Thanks, Jim
-
Breakback with rounded integer numbers
Hi, Is it possible to set a Breakback function with auto-rounding? We're working on a project where exploiting breakback is useful. Product units should be integer, never fractional, but we can't find how to auto round numbers derived from breakback function without setting a process. Is there a way to let user insert a…
-
How to get the first non-blank value from a line item to another module
How to get a value to another module for the given selectors, the first one which is not blank? I always have one value in historical sales name and I want to transfer it to another module. And then how to transfer the value that is next to the line item Value Min
-
How to Automatically Generate an outlook Email with Specific Format from Anaplan Page
Hi Anaplan Community, I’m trying to automatically generate and send an email from an Anaplan page formatted as follows: TO: (Predefined recipient email) Subject: Text [dd-mm-yy] Attachments: (Optional or specific data if applicable) Body: Hello, Please see below the details: Line items: Timeline: "Start week - End week"…
-
Managing number formatting between countries
Hi everyone, I'm looking for advice on how to dynamically change number formatting in both the Anaplan model and UX based on the region or country. We have a development model that will be deployed across two countries, but they use different formats for decimals and thousands separators. For example: Canada uses a comma…
-
How can i set up this filter ?
I want to allow users to input a text field with items separated by commas (e.g., X1,X2,X3,X4,X5 ) and, after clicking a boolean (e.g., "Select"), have the page filtered to show data only for the specified items. How can I set up this filter?
-
Is it possible to display different line items in one module for different levels of a hierarchical
Hello, I created a module that has a hierarchical list structured as below: I added line items to the module such as: -Revenue -Lattitude -Profit -Count Active -Count Closed -Count Open But it is not important what line items I have, what is important for me is how to make it so that after selecting, for example, an item…