-
Import Financial Transaction Data
I have a financial transaction file I receive every night. This file contains multiple rows that contain the exact same data in each field. Is there a way to import these rows without failing the duplicate checks?
-
L2 Course - Supply chain model INV05 Shipping Export
Hi, Any expert please help , I am stuck in Importing G3 location in "INV05 Shipping Export" module , I alreay crteated Subsidery view doe CODE line item , in this Module , but while importing Data from G3 location List , it is ignoring the Parents like "US", please help me to understand what is wrong in steps , please…
-
Circular Reference Problem
Hi All, I am having a circular reference issue in my calculation. Module A : Is dimensioned by Cost category List, Cost Center List, Time and Custom version List. (source module for forecast) Module B: Contract List and Time and Custom version List. (source module for Actuals) Module C: Is dimensioned by Cost category…
-
delete
-
how to average on roll up
I have a module where I have sales per country. I want to average sales and not add when I roll up to region or when I chose region from drop down. How can I do that?
-
Is there any way out restore the history of QA model without breaking ALM?
Hi All, We have one case , where we need to restore the build & Data pushed in QA & Dev Model. Thinking of following Approach . Please advise if there is any gap or other way out : QA to be change the Deploy to Standard mode Restore the QA model from required History ID Post the successful of restore the QA will be get…
-
3.3.5.3 check your work numbers are out (most likely Dem03)
Hi team, Working through the level 2 model builder course and have hit a snag. My Dat03 Historic values is populated and working as intended with the forecast year pulling the value from the previous year I believe my demand forecast is also working as intended with FY21 pulling from FY20 My issue is my final forecast is…
-
How do I use a line item formatted by a month for mapping in a column dimensionalized by time
I have a value (in this instance it is the number 13 in January 24) that I need to populate in the line item below it in the month of February 25. The entire module is dimensionalized by time (month). The Feb 25 formula is an add months function that references an input from a different module based on the quarter of the…
-
Formula SUM
I have A List of Farms - 'FarmNames' - showing the Farm name, and a Property - 'Shop NameShop Name' -which shows the shop the farm serves. A module - 'Farm Apples' - showing the name of the Farm, and the manually entered number of apples by month for the past two years, where apples is the only line item. I want to show -…
-
How to Bring in Value from Other Module
Hey Everyone, I've been working on Anaplan going on a year and still working to build on my modeling skills. I ran into an issue with a live production module we have. I have two modules I'm dealing looking at: Module A - Dimensioned by tiers (Range for achievement bounds), E1(Employee list) subset on a component type and…
-
How to edit the display name property of a numbered production list in a deployed model?
I can add items to the production list but can't edit the display name. Ps. It's a deployed model
-
1:1 allocations in dependent Line Items
Hi, im quite new to Anaplan, so I do not know several features. I want an 1:1 allocations from a List to a List/Module Im working with Line Item Dependency, that works so far, that only child items can chosen from the same parent. But what doesn't work is that I mustn't select multiple times the same item. i tried with a…
-
Multilevel Adjustments Removal of checkboxes
Hi Everyone,I am working on a requirement where the customer wants adjustments at multiple levels and we are working with multiple hierarchies so there are a lot of combinations (total level combinations also needed). Now at the dashboard level the user comes in and selects levels from dropdowns and then clicks on a…
-
Multiple approvers in workflow for the same step using a module to define the approvers
Hi, does anyone know of a workaround to have multiple approvers in a workflow for the same workflow task, using a module to define the approvers? Most of you probably know this is possible if you define multiple approvers "back-end" in the step itself. Then you have the option to define if all approvers need to approve or…
-
Anaplan IRR different from Excel IRR results.
Any reason this IRR can't be calculated? In Excel it's properly calculated. However in Anaplan it can't be calculated
-
Returning a Blank in a IF THEN ELSE statement involving a list
Hi, I am looking for a way to return a blank for an IF THEN ELSE formula involving a list: IF x AND y AND z THEN Values to lookup[LOOKUP: Mapping] ELSE Return a Blank The Return a Blank part is what I am having an issue with. I can't use 0 or "Null" as the format of the line item is a list, is there a way to return a blank…
-
List Hierarchy Update Failure
Hi All, I am trying to update a composite list hierarchy with 2 levels they are both Numbered List. In the source module the List being imported are NOT a numbered List only in the PROD model it is set to a Numbered List. Here is the Parent List and Code is concatenated with _L1 Below is the child list that Rolled up to…
-
Hello! How to set value as TRUE based on other line item value
Hi everyone, I'm wondering if someone could help me with this. I would like create module like picture below. I have general list "Summary SKU" and "Detail SKU". These general list are not having parent-child hierarchy for each other. Then, in Line Item "Delete Detail SKU", user will check the Detail SKU they want to…
-
Case - % Increase on Previous List Item
Hi All, I am working on one use case where need to calculated the value on the basis of previous list item. Module doesn't have a time dimension. But I've created mapping module to identify the previous item. Please see below screenshot for your reference. Final Value = Previous (final Value)* % increase. Can you suggest…
-
How to Apply Filter in a module with respect to Dynamic Time filter
Hi, So I ran into a situation where we had provided User specific Dynamic Time filter for Months/Quarters/Year. Now I want to Display only Non-zero Values in my Module W.r.t the Dynamic Time Filter. So, If I select Quarter FY25 then only those line items should appear which has values and when I change the Dynamic Time…