-
Time Dimension Sum For Reporting
Hi Anaplan Community, I will be grateful if you can share your opinion on this problem: Below is the scenario need to solve: I need to transfer the "Amount" based on the "Collection" week as shown below I used the POST formula: Amount: XX Week Count: ROUND(('Date + Count' - Date) / 7, 0, DOWN) POST: POST(Amount, Week…
-
I have an input module where I need to enter value (%) and it should sum up to 100%
I have an input module where I need to enter value (%) and it should sum up to 100% and once it reaches 100% we should not be able to enter any more value. The values will be random and not equally distributed like in Breakback. Please suggest.
-
Level 1 Exam. Correct formula to calculate the totals by region and roles.
What is the correct formula to see the result for items below by Region and By Role?
-
Get Data From Combination to List item to Line item
Source: We have combination list and its properties with QTY value Target : I am using individual list except Application.i want application value by line items. Without using Application Dimension. Application is PRoduction List Tried ComboApplication colume= SYS module Application but not returining 0
-
Calculating in a ragged hierarchy?
Does anyone know how to do a calculation in a ragged hierarchy which returns to the level of the hierarchy?
-
How to sync a selector field with input grid in anaplan
How to sync a selector field with input grid in anaplan
-
Ragged to Balanced Hierarchy
Please can someone give the step by step points in an easy way to convert a Ragged Hierarchy to Balanced Hierarchy in Anaplan. Thanks!
-
Filter the Hierarchy Level
Hello all. A few days ago I saw a "How I Built It " video regarding the Hierarchy filter which taught me how to use Ratio Summary for filtering . I wanted to replicate the same structure but here is the thing. I created a module for filtering Group level ( higher level ) or Product level ( Lower level ) like the picture…
-
Time Problem ASAP
Hello everyone , I have an old model with a time scale of 2023 and 2024 and after that I wanted to add 2025 in the time , some models take in consideration the next year , others not ! Is there any of you who faced this issue before ? If yes can you provide me pleasewith the solution. For me : I doubt that the problem…
-
Is there a bug or... Show/hide level filtering doesn't have an effect
There is a need to filter levels of subset but it looks that it doesn't work. Level filtering works good if you have a list. Is there a bug or… (subset is built with boolean rule). Pic1: trying to filter levels through Show/hide option on board Pic2: even selecting / unselecting levels, there is no effect on board to…
-
Level 2 - 1.6.3.2 Import Data into DAT04 Distribution Center Parameters Module
L2 - Sprint 1 - 1.6.3.2 Import Data into DAT04 Distribution Center Parameters Module * Download data file: Weekly Safety Stock.csv. * Import data file into the DAT04 Distribution Center Parameters module. I am trying to do the mapping Distribution tab map is not coming properly Please help to resolve the issue . Regards,…
-
4.8.2 Activity: Import Data into E2 Employees# List.
4.8.2 Activity: Import Data into E2 Employees# List. How will we fill this place?
-
I need to build a Slope and intercept formula where my X values are dates.
I need to build a Slope and intercept formula where my X values are dates. Like in the screenshot. Since in Anaplan (the normal build) way we calculate by using the formula as mentioned. How to convert dates into number format or otherwise how can we achieve the same Example :
-
How do I get a line item to stop defaulting to the working forecast version?
I have a line item in a module that keeps defaulting to the VERSION.Working Forecast of a value. We have four versions: Budget, Working Forecast, Actual, Forecast For some reason when I use the SELECT function it keeps defaulting back to the working forecast version. This is the current formula: I tried to fix it by adding…
-
ITEM function in module with Line Item Subset
Hi All, I have a module that has line item subset as one of the dimensions.. Cost Center, Time, and Line item subset. The line item subset has three members, A, B and C. You can have input on them, however, C is the total of A and B. If it was a regular list, I would have the something like —- IF ITEM(LineItemsubset) =…
-
Custom Switchover
Hi, I want to build a custom switchover for Fake version/List I created separately (Actual, Forecast, Rolling Forecast) I created a custom switchover time period 2. Then I created a custom switchover period 3. Next, I have the module where I want to apply the formula, however its showing Circular references: values Result…
-
model to model import : Failed to locate model
Hello Anaplanners, I am working on a deployed model and i am getting this error when i tried to model to model import data : 'Failed to locate model ' Can anybody help me on this. I am attaching the snip below FYI : I am having full access and admin access to both the models. THANK YOU 🙂
-
Minesweeper: How we Built it?
Do you remember the good old days when we used to play games like Solitaire, Minesweeper, Pin Ball, Checkers, etc in your big and bulgy desktop? Oh! Those were the golden times of youth, even though we cannot match the high-end technological development in graphics, storyline, real life game play, regular updates but the…
-
Keeping the length of the record constant
I am looking for a solution to keep the length of the record constant to 10 digits. For ex if I have 7 records like this 1) 1234567 2) 123456 3) 12345 4) 1234 5) 123 6) 12 7) 1 Then I need to achieve 1) 0001234567 2) 0000123456 3) 0000012345 4) 0000001234 5) 0000000123 6) 0000000012 7) 0000000001. I can achieve this in…
-
1.3.3.1 Level 2 Model Building: Sprint 1. What is the correct way to Map this.
I'm confused by this e rror
-
Copy a branch to another Parent.
I want to Copy a branch to another Parent. The hierarchy is 5 levels and i want to copy an item at level 3 and all its children to another item under level 2. All suggestions are appreciated!
-
1.1 Import Shipping Costs from Supply Chain
Level2でImportアクションを使用する箇所でのマッピングに疑問があります。 OTH01 Non Employee ExpensesへShipping costsをインポートするのですが、 なぜ「Fixed line item」ではなく、「Column 2: Line Items」を使用するのでしょうか？ そもそも私がインポート定義を理解していないことも原因と考えられます。 参考になるページがあれば追加で教えてほしいです。よろしくお願いします。
-
Filtering based on initial 2 letters
I want to apply filter for users based in initial 2 letters of data. So, if initial letters contain say (ac or bd) then user group A shall be able to see only data having initial letters ac and user group B shall be able to see only data having initial letters bd. Any suggestions on approach , please?
-
Activity : Filtering and Displaying Hierarchical Data
I want to create an interactive anaplan module that allows user to select an item from a hierarchical list and dynamically display associated items from the next level in the hierarchy Lists : P1 Product Family ( LVL 1) P2 Products ( LVL 2) P3 Products SKU ( LVL 3) Requirement : When a level 1 item is selected , display…
-
Separate into Several models
Hi. We will start a new project. In previous project, we made 1 model in 1 workspace. Off course, we have several models like (sand, test, Production model). It means we had several information in 1 model like (HR, Marketing so on..). Then, we can make separate models like HR model and Marketing models ? And We can share…
-
Need to know if we can take out some GB from 1 workspace and put that space into different workspace
Hi, I have a question where I want to split out like 30 GB from one of my workspace and put that 30 GB into different workspace. Current Situation Workspace 1= 130 GB Workspace 2= 300 GB Required Situation Workspace 1 = 160 GB Workspace 2= 270 GB If its possible how can we do this. Thanks
-
How to Split A Model into Two Separate Models
Hello All, Our current model is about to hit the max workspace size of 130GB, so we divided it into two models based on the region. Imagine having 1000 stores, and creating a new model with 500 stores. My question is how to remove those 500 stores in the new model from the original model. What are the best practices and…
-
Compare two lines items from different modules
Hello This is my problem. I have a line item A in one module dimensioned by "Depense" list. And I have the line item B in another module dimensioned by "Achat" list. I want to compare if A = B then the item of the list Achat become the parent of the item of the list Depense. I cannot pull any finditem. Is there a way to do…
-
Lookup on Parent elements
ello anaplan Community, Hello anaplan Support, we stumbled upon a problem that seems to us like a functional error of anaplan. Example Setup: List "List_A": * A * B * C * D * E List "List_B" * a* aa * bb * b * c * d * e Module "Module_A" Lists: "List_A" Line-Items: * Value_B: Formula: B_Module.Value[LOOKUP: Lookup_B] *…
-
Referencing a list property
Hello fellow builders, I'm a bit hung up on this. I want the Display Name formula in the "Job Title by Cost Center" list to follow the same naming convention in the "Cost Center" list. For example, I want "BOBL-CAACPAY" to be "Accounts Payable (BOBL-CAACPAY)" The two lists are independent of each other, i.e. there is no…