-
What is difference between: ITEM & FINDITEM
EoM
-
Unable to infer employee-region relation given employees have accounts and accounts belong to region
Hello all, I am building a standard org. hierarchy consisting of employees, accounts and regions with the following rules: 1) Each account can be assigned with only 1 employee. 2) Each account belongs to only 1 region. 3) Each account for one employee is within one region. For some calculation purposes, I need to know, to…
-
Add a date stamp
HI All, II need to add a state stamp into a table. My plan is to have a Line item that somehow calculated the current time (equivalent in excel would be NOW()). I then plan to use the Import data to import that date into a static date line item in the same module. Does anyone know how to get Anaplan to show the current…
-
take a value from another module
I have a module named AAA like this: lowerupperPayout ratetotal invoicestatustranche 105000%$ 8500tranche 25009002.5%$ 8501tranche 390012003.0%$ 8500tranche 4120015003.5%$ 8500 And another module named BBB: QuantityValues $Rate Appliedproduct 148000$ 250?product 2 $ 210?product 3 $ 200?product 4 $ 190?TOTAL $ 850 I want to…
-
Data from one module to another module
Hi 1st Module I have expense list(5) and key figures list(6) with boolean line item (Check) .For each expense will check different key figures Another module Dimensions - Index list , Time and Versions Expense List formatted line item Key figure list formatted line item So when I select particular expense from the drop…
-
Filter for Module
Hi, Having a hard time setting up Filter in the Module. I have created a Line Item in My Systems Time Setting Module that Boolean checks when a day is a Weekday and not checked when a Weekend. I need to know how to pull this filter into my Module. It is not giving me the option to do so and Im not sure why. Thank you
-
Sub percentage allocation based on different attributes
Hi I have one module with dimensions of Index list(Numbered list), time,versions I have 4 line items 1st- cost center-list formatted 2nd-Planning-list formatted 3rd-Business Area-list formatted 4th-Percentage-Number formatted(%) so cost center1-Planning Account1-Business Area1-I will enter %(20%) cost center1-Planning…
-
Find the position of nth time a character appears in a sting
I want to pull the description details from the History log. I have calculated the number of commas before the Description column which is 3 but I am not able to find the position after the 3rd comma to extract the Description data for multiple rows. Row 1 - ID,Date/Time (UTC),User,Description,Security Change,Previous…
-
How can I set conditions (IF THEN ELSE) when the first argument of my IF statement is not BOOLEAN
Hi, Would like to know how can I set conditions (IF THEN ELSE) when the first argument of my IF statement is not BOOLEAN formatted. What I'm trying to do is put conditions on my Row's A+/A++...ect to determine what number (6,9,12..ect) they will fall under. I have a pic attached. Please advice. Thank you
-
Daily Rolling Forecast
Hi, I'm trying to set up in my Time Systems module a Daily Rolling Forecast, but having some trouble making it work. I have attached pics of what I have done. Please advice Thank you
-
Sum Error - Mismatch
Hi, I am attempting to bring in the sum of one line item from one module to the next and getting the error: Data type mismatch: format other than LIST or DATE being referenced as a relation Here is the formula that is failing: and the referenced module: Thanks!
-
Parent to Child Lookup/Selection - Part II
Does anyone know if there a best practice around sourcing data where the target module is dimensioned by a parent list and the source is a child list? Target Module: Roles Dimensions: Team Roles, Staging Opportunity Target Line Item: SF User ID Formula: Teams.'Item: SFDC User' Source Module: Teams Dimensions: Staging…
-
POST n periods later
Can someone explain to me in plain English what the POST n periods later line item is doing in this screenshot? I understand what POST to a later period does, and what POST to an earlier period does, but I don't understand how we are getting 3,000 in the yellow highlighted cell here: Any explanation would be appreciated.…
-
Getting error while applying lookup
Getting an error that The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid: Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details Module'.Country, LOOKUP: 'SYS06 Product Details'.Product Family] 'REV04 Price Growth Rates'.Unit Price% is not a recognized line item or…
-
How to search Sort option?
Hello. The new Action "Order List" is added. So I tried to change "old sort option" to "Order List Action". The Refurbishment step is below. Step 1 : Search all modules which are sorted by Line item. Step 2 : Change to Order List Action. But when I do Step 1, Another Sorted Information has appeared like this. I think this…
-
Time Setting Module
Hi, I want the Line Item "Current Week # of the Month" to show Current week number of the month when Line Item "Reference Date" is selected. Thank you
-
Query regarding history log
Hi, I needed some clarifications regarding the history log. There are some columns in the log which represents individual lists and there are some lists which are not a part of the log. So my question here is which lists under general lists are part of the log as separate columns and which lists are not.?
-
How to input for the first Item while using the Previous Function
Hi, I would like to know how I can input the first number that I need my Previous Function to read from. I know I need to add to the formula but not sure what to do. Please advice. Images attached. Thank you
-
How to consolidate 3 lists part of same hierarchy
Hi, I'm building an FP&A and is right now working on the FTE part. I have three lists: 1. E4 Employees # - this is the main Headcount file from HR 2. E4 Recruitments # - this is the monthly recruitment file with people that are signed to start in the future 3. E4 New Asks # - this is a list populated by users going into…
-
Import Code to Numbered List from Saved View
Hi, I'm trying to import the code that is automated from a saved view module based on the Numbered List. The user adds people to the list based on a form but are not adding a code to the people. This happens in the module based on the list and is automated without user interference. After this I want to import a saved view…
-
Is best practice to have flat lists in spoke model or only hierarchy?
Hi, When building saved views in the data hub to export/build lists in the spoke model is it best practice to first build flat list in spoke model and then have the actual saved view building the hierarchy in the spoke model, or should that saved view module building the hierarchy be already be in the hub? Best regards,…
-
Add value to a given Time Duration
Hi, I have a Module A with the following line items, format, and data: value(Format = Number)start(Format = Date (mm/dd/yyyy))end(Format = Date (mm/dd/yyyy))101 1/1/20192/1/20192013/1/20194/1/20203015/1/2020blank I have another module B with Time Dimension and a Line item - value_over_months that will be mapped to module A…
-
Question on Time setting Module
Hi, Trying to create a Line Item "Week # of the Month" that will give me from 1-4 the week number of each month when referencing my "Reference Date" ex) with Reference Date "2 Jan 19" the outcome will be Week 1 or in formula &"Week"&.... any help on this will do. Thank you
-
Best Practice for importing lists from DataHub - From list or Saved View?
Hi, I'm wondering what is the best bractice when having a datahub and a spoke model and you want to get the lists up in the spoke model. Is it best to simply import lists directly from the hub to the spoke, or is it better to build modules in the datahub with the list as a dimension along with its details as line items and…
-
how to get the beginning month of the current year in a line item
Hi, for your assistance please. How can I get the beginning month of the current year based on the a line item which is Month format from a line item data converted from a number format to a date format? I created a system module but I cannot use it or refer it because the data that I need to get should refer to the line…
-
How to omit time ranges from Applies To
Hi. We have a table has applies to(Region, Time). The table has line item "temparature", We added line item Time=item(time). When we export the table from anaplan, We want omit Applies to not only region but also Time. How can I omit it.
-
Using NAME with Numbered list
HI, I have a numbered list - 'employees' with the display name property set as Display Name. I have a system module called employee details dimensioned by employees list. I have created a text formatted line item in the module with the following formula NAME(ITEM(employees)). I expect to see the display name of the line…
-
Setting up SYS Modules for Time Settings
Hi, What function would you use to display the numbered week in the Month, ex) the third week of the Month.
-
Setting up a Time Setting in Model
Hi, I would like to know how I would set up the Time Settings in my module so that I'm able to see the actuals for the day Selected, and then Forecast Numbers only after that day? Thank you
-
Versions Question
Hi, I'm trying to set up my Model so that I can View the Actuals for the actual day it is and then after that just forecasted numbers. My Model is set up in Days of the Week and want to be able to view actuals for that certain day and then Forecasted numbers after that. Do I use the Switch Over function? and How? Thank you