-
Find common text between another modules without List
Hi, I want to find common text between another modules. I have two modules A&B. Each module has order Number and Product(Text format) I want to find Product(ModuleB) in ModuleA. It's Common Text. In this case, we can find product by finditem formula, by making product List. But I don't want to use product List, because it…
-
Cumulate calculation but skip 1st item
Do you have any ideas to calculate this; what I need? If I make a line item called "for lookup" and use LOOKUP formula, I can do this. However I need to fill in "for lookup" manually. I simplify the case here and "Figure" should be calculated using "What I need", so I cannot use "Figure" since it becomes circulation…
-
1.4.5.2 Import from Saved View
Can anyone help me with the mapping of this?
-
カテゴリー別合計が上手く出ない
作成したいのは赤枠モジュールです。 指定期間の数量Aの合計をカテゴリー別で出したいのですが上手く出ません。 お力添えいただければと思います。
-
Concatenation in module failing
Currently looking to concatenate a number of fields on an existing module, which seems to work for some of the fields, however not for all. In the example below it is the Ent Code that doesn't seem to work - I've included the design view as well for reference
-
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…