-
How to create an Error action to stop the process
How to create a simply Error action to stop the process, Such as use a False/True filter, I want to stop the process when other user execute the process in the same time… Thanks
-
L3 Model Building Sprint 2 - User Story 3.3
サンプル画像のJanell Wetzelのデータと比較をするが、どうしても少しずれてしまう。 ① SYS01 Time Settings by Monthで、月ごとの年に対する割合を算出した。 ② ①をYearValueを使用したTargetと計算し、月ごとのTargetを算出した。 ③ 月ごとのTargetにNet Commission %を使用し、算出したが計算が合わない。 考えられる原因としては 1.Days in Monthが間違っている 2.Net Commission %が間違っている だと考えているが皆様の意見を伺いたい。
-
Sorting - List Members
Is there a certain trick or a set of procedure to handling sorting list members. I can control the first creation of list and import the record in sorting order but how does future addition to the list should be done so that they are always alphabetically sorted. I notice that after the first load, newly added members gets…
-
I NEED HELP ASAP
Hello, I am creating a new model "production" from the revision tag of "dev". The steps i followed : 1- create a model from a revion ( done) 2- doployed the production ( done ) 3- import data from Data Hub ( done ) 4- import data from dev to Production via a revision tag ( failed , the action run correctly but the data…
-
Too many cells for ISFIRSTOCCURRENCE calculation
I Import a C11 list to 2 spoke models from Hub. I use the same DataHub and Same Hub Saved view to import into this list. However the import into list is sucessful for one of the spoke model but not the other. The saved view and the import definition is the same for both the spoke model. For one the process is completed…
-
Quarter to month
Hello ^^ How can I convert a line item formatted in quarters (e.g., Q4 FY23) to a line item formatted in months, displaying the last month of each quarter Q4 FY23 =⇒ Dec Q1 FY23 =⇒ Mar etc Thank you
-
how to copy a lIne item from a module to another one ( Text format )
Hello, I hope you're doing well. I'm facing a challenge and could use some assistance. I have three line item text formats in a system module, and I need to retrieve the information in text format from the same line item with the same name from another module. Here's what I've tried: I went to the target module and simply…
-
Percentage Format issue on UX page
Description: I have a module with PV(dimension) Filters as dimension and I am displaying the Value line item on UX which is same as the Module dimension. But the Value line item is getting the data from other line item Actual vs Scenario 1 % which has ss_Actual vs Scenario 1% (dimension) - Which is a subset of PV filters…
-
"Invalid name" error
Hi all When I try to import into a list I receive the error "invalid name". Do you know where I can find the explanation of this error? Thank you. Pic attached.
-
Write a DCA logic to prevent entry from another User if the selected row reserved by another user.
For eg. In the above screenshot if I check reserve row Boolean then the entire column of that row should get lock for other user and only editable for the person who reserved it. Also i want to see the name of the user for whom that line is reserved for.
-
Copy of list item
Hi, I would like to ask if there is a workaround for this: If I copy List Item 1, the copy should have a "-1" in its list name automatically. The list is a numbered list. TIA. :)
-
Import Failure
Actual- Mine- Any help here? Edited- After selecting department as sales, still '82' are Ignored Additional info Supply chain - FP&A model, level-1 -
-
Will lag function works for Boolean Formatted Lineitem?
Hello Community As Anapedia says, lag function can take Boolean formatted lineitem I have a scenario as below I have a module dimensioned by Numbered list and Time scale And I have 3 lineitems as below 1. Lag value - — boolean 2. Lag offset Amount ——Number 3. Output lag ——Boolean Formula for lineitem Output lag = lag(lag…
-
Quarter to Text?
Hello Community, How can i go from the line item Quarter ( Quarter ) to Quarter ( Text ) example : Q3 (Quarter format) to Q3 (Text format) Thank you
-
User access
Hi friends I need to publish a module to the dashboard, there are about 10 line items in the module. One user should only be able to see the first 3 line items where as other user should be able to see last 4 line items and so on. I need a solution for this problem. Thanks in advance.
-
Synchronize selective acess with line item using selective Access
Hello all, I have been wondering about a functionality with Anaplan. I created a technical list that i added in Selective Acess (in red) Now, i have a module who has a line item with the List Format of my technical List, but the module dimension is using another dimension. I was expecting to see that when i set my line…
-
Two dimensions and Bi-Monthly Formula
RESOLVED: I am trying to write a Formula for Bi-monthly value which also needs to consider in monthly level into 4 parts 0 - 1000, 1000 - 2000, 2000 - 3000 and 3000 and above Here, I create a custom timeline for Bi-monthly calculation. for example: Jan (1- 15) has 2500 and Jan ( 16 -31 ) has 3100. Hence total Jan has 5600.…
-
Headcount Growth Assumptions Logic
Hi Anaplan Community, I'm working on a growth assumptions module in my Anaplan model and could use some guidance on achieving a specific distribution. Here's the scenario: In my growth assumptions module, I have two line items: Beg HC (Beginning Headcount) and Joiners Percentage Growth. When a percentage growth is entered…
-
Level 3 Sprint 2(User Story 3.2) QUO04,QUO05,QUO06Moduleの使い方
SYS07 Sales Rep DetailsのTenureを作るためにQUO04,QUO05,QUO06Moduleを使用して計算をすると予想しているのですが、QUO04,QUO05,QUO06Moduleでは何をするべきなのか見当がつきません。情報が少なすぎます。少しでも良いのでヒントをください。 質問1. QUO06の「Start」「End」「Tenure?」の各ラインアイテムは何を指しているのか? 質問2. QUO05の「Code」「Number」だけのラインアイテムは何を目的としたラインアイテムなのか? 質問3. QUO04の「Low」と「High」の意味が分かりません。何についての「Low」と「High」なのですか?
-
How to sum the values of specific days of the month. Ex. sum the values of all the mondays.
Hello, I have a requirement for the client to find the ratio of the days of the week over the value of the month. To do this I need to sum for example the value of all the Mondays of the month and then divided by the value of the month. I though about making line items with just the value of that day of the week that I can…
-
Show a name different then line item
Hi in a application, how do i change the name of an line item? Thanks
-
Conditional Parameter
Hello, I hope everyone is doing well. I have a query regarding Anaplan. I have several system modules where I have created unique IDs, each with a different length. In the user experience (UX) part, it's the UX user who chooses the name of the file to import. Then, the ID becomes the File Name + ID. For example, if the ID…
-
Text to quarter ?
Hello Everyone, what is the best formula that we can use to go from this to this: Txt Period "Format Text" (Example: Q1 FY24) ===> Quarter "Format Quarter" (Example: Q1 FY24)
-
Boolean to time period
Hi I have a boolean line item checking months from jan-dec 2023 and I have another module which is time period formatted(months).I want a formula that applies to the first module through 2nd module that when a user select months from module 2 then the boolean is checked automatically in module 1.
-
MIN Function Help
Hi, I'm trying to get the MIN for Customer Tier based on the parent customer of the chain. Any help to understand what I'm doing wrong here? I'm trying to get the specific line items to adopt the MIN, not just the parent. I.e. if the MIN is 2, I want all the child stores to equal 2. Thus in the example below, all stores…
-
Optimizer Help
I am trying to learn and understand how optimizer works in Anaplan and need some assistance in overcoming a roadblock. I am going over a practice problem that I have created in excel and am having difficulties with one of the constraints. The Problem: Without getting to into the weeds this practice problem is about making…
-
Avoiding the same priority values for different items
Hello everyone, I am facing a wall regarding a dev… Here is the need, i have one table, with a dimension called : Layer 3 This table is published in a dashboard, where users can imput data on the column "Layer L3 Priority" displayed in yellow. Now, i was asked to do the following : "We don't want the user to imput…
-
How to sum a previous period value and current period value (multiple times)
Hi all, Have been trying to sum the values from the last week and the current week to obtain a new cumulative value; this value will be the new value to be added to the current week value. Unfortunately, this does not seem to be so easy in Anaplan. WEEK1 I start the first week with one value (layers-actual) and, of course,…
-
How to add time dimension to existing module
-
Delayed amort of assets at category level
Hi Team, Need some help with a bit of a head scratcher. I am working on an asset forecasting module at a category level (due to requirements outside of my control we cannot input the values in at the individual asset level). The categories are in their own list and I have a simple module that houses their life for…