-
Version label question
Think I already know the answer to this question but just wanted to double check with more experienced users. We are operating with forecast versions as a list and a version selector as a system module, screenshot shown below. This works fine, other than ideally in the report we would have the Version 1 and Version 2…
-
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…
-
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
-
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.
-
How to sync a selector field with input grid in anaplan
How to sync a selector field with input grid in anaplan
-
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?
-
One to many mapping
Hi, I have a requirement where i want to realign/ redistribute the Sales History from 1 SKU to many SKUs. Lets say, i have SKU A with 1000 units sales history. I now need to realign 400 and 300 units from SKU A to SKU B and SKU C, who have 500 and 200 units sales history of their own, respectively. So after the…
-
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.
-
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…
-
Workspace
Hi Community, Anyone have idea about 90 days free workspace. I mean what about after 90 days. Is it chargeable or it will discontinues after 90 days
-
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…
-
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…
-
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…
-
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…
-
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 :
-
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…
-
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」を使用するのでしょうか？ そもそも私がインポート定義を理解していないことも原因と考えられます。 参考になるページがあれば追加で教えてほしいです。よろしくお願いします。
-
2.3.11.2 Create Line Chart Saved View
Hi, I can create a filter here in terms of months but I am not getting data for the line chart, where am I going wrong? Please help me on this.