-
Lookup on text format
Is there a way to lookup on a list property of type "TEXT" from a module that has a property of type "TEXT" I have in module a property Index( Text) abc efg ijk lmn In the list I have a property Index(Text) Index Index value abc 1 efg 2 ijk 3 lmn 4 I thought List.Index[Lookup:Index] will work since both are of type text?…
-
How to use collect function on a particular version?
Hi, I am trying to use Collect() function to collect a value on a particular version by using Line Item Subset ,but it is only collecting a value from only one version to other versions. Please suggest . Thanks in advance ....
-
SUM Rows and not the Summary
Hello Everyone, I am new to Anaplan and I was wondering if there is a way to sum rows but not the Summary of them. For example in the module, in the rows I have the Employees List and in the Columns I have the Line Items and under these the Business Units Abbreviation List. In the Business Units Allocation Line Item it…
-
RE: Model consolidation
Hi Fredric Make sure you have built your lists in relations: SKU List parent list is Products (Assuming SKU is your lowest level) Product Parent list is Region (Organisation) so on, If you have not created these relations the other way would be let SKU have a property called Products and Region and then get the respective…
-
Unique ID Number
Is there a way to have my Anaplan model assign a unique identifier number to line items in a budget? I plan to load a budget into my model and would love for the system generate a unique identifier number for each item in order to reduce risk of human error. Currently in my Excel budget file, the unique identifiers are…
-
Identify duplicate list members
looking for logic which would support identifying list members duplicates via conditional formatting. A numbered list display name can be repeated. Looking to highlight (conditional format) those that are replicated.
-
Number Scaling in Modules/Dashboards
Most of the time, I want to report my financials in either Thousands or Millions. Although I could likely add a "/1000" or "/1000000" to my formulas, I prefer to maintain the integrity of the original data by just displaying in either thousands or millions (rather than changing the numbers themselves). Is there a way to do…
-
Day to month custom time scale
Has anyone ever built a custom time scale that can handle days to month? For example, we forecast future heads to start at the daily level and I need that to map up to the correct month. The days rolling up into 4-4-5 or other week options throws off my monthly calculations significantly.
-
Copy store data
Hi there! I am aware that Anaplan now has a Copy Module function. However, is there any way to duplicate an existing "Store" and its relevant data? I have a list of Stores as shown in the screenshot below. Thank you.
-
Ratio to all & Ratio to parent within a list
Hi all, I have a module with a single multi-level list (category, subcategory, product). The 'all' level is called 'All Products' I need 'weight to parent' and a 'weight to all' line item formulas to use in my calculations. It's coming unstuck when i try to look up the 'denominator' for the weight calc. eg the value of the…
-
Model building error
Hello, I am trying to add line items (Sales Unit) to a new module , but I am getting an error "Circular reference: Sales Unit". Any help is very much appreciated. Plesae find the screenshot attached. Thanks Suneesh
-
Querying a Transaction log
I am using a numbered list as the dimension for a transaction log which stores changes to a people count line item applying to 7 dimensions (list items). The numbered list has each of the 7 list items as a property (format type list attached to the appropriate list item). I want to populate a line item that has been…
-
Validation
How to enforce users to enter specific value in line item. E.g. I want user to enter only positve value in number line item. Line item should not accept any -ve number OR user should not enter value more then 100 etc.
-
How to multiple access control for 1 item
Is there any method of multiple access control for 1 item? ex. Supplier List (with selective access) Supplier A Supplier B Plant List (with selective access) Plant X Plant Y Item List Plant(Property)Supplier(Property) Item1Plant XSupplier A Item2Plant XSupplier B Item3Plant YSupplier A Item4Plant YSupplier B User Settings…
-
Display Properties from a Numbered List
Is there a way to display across in a module, the "Properties" field names from a numbered list? In the list below there are four property fields I'd like to display across in a module in the "rows" section where currently there is just one column - first row is "Virus Protect."
-
Bill of Material for BOM Costing
Hi, What's the best way to build a multi level Bill of Material (for a Manufacturing company)? The scenario is that the final product can have multiple BOMs and also have many layers of child components many of which can be Semi Finished product themselves. Suggestions will be appreciated. Regards
-
Formula for entering value
Is there a way to use a formula to calculate the value your are inputting into the cell? For example, if I'm loading a forecast and am inputting the forecast value for a specific month, I'm looking for the ability to say that value should be =2+3 instead of having to key in 5 as a simplistic example. Otherwise if I have…
-
Account Hierarchy
Hi! Is there anyway to setup an account hierarchy reference? For example I have some accounts in SalesForce that have both a Parent Account and a Child account. I'd like to get this list put together to act as a reference to see what other accounts are part of the same family and be able to show this relation in a…
-
Bulk Copy within a Single Module
Can I bulk copy data and formulas within a certain module? I want to move all of my actual data from a previous year into another version, but only for one specific module. My only solution so far is to export the data and reimport, which is tedious. Any information is apprciated. Thanks, Mark
-
Recursivity - Button to copy from one module to another
Hi Anaplan, I have an issue with a modele that requiere recusivity to optimise a KPI. My manual solution is the following : * I enter a paramater (let's call it A1). * Anaplan compute this value and give me the matching KPI. * at the same time modele produce a better value A2 for A1. Then i can copy this new value A2 into…
-
Top Level of Numbered List
I have a module which applied to a Numbered list. I have applied Top Level and Parent Hierachy to thist list. However in the module, Top Level total doesn't sum up the amount in the list, in fact it doesn't show anything. is this a bug?
-
YEAR() function not working
My Fin Year item is set to Time Period format: "Year". Our financial year setting is April to March. Attached is the Anaplan example and my working model that seems to return different result. I would expect that in calendar month/year, May 2016, that the Financial Year time period would say FY17 (appears that is the…
-
Select Multiple Items in a List as Property
Hi, Is there a way wherein I will be able to select multiple items in a list as a property? For example, I have a list of routes. Each route has its destination countries. I've created a list of countries to be used as a property of route. Scenario: Route: Manila - Sydney Property (List of Countries): Manila Sydney Thanks…
-
Data Copy from One Version to another
Hi All, Can any one please let me know how we can copy data from one version to the other . For example if i want to copy data from Forecast_May to Forecast June for some intersection like FY16,for a particular account, for a location.Entity Thanking you in advance Regards Sasi
-
importing from one model into another
I need help. I have a HUB model and a Quota model. In both models, I have an identical module in which I'm trying to import from HUB to my Quota. Both modules are using 2 lists. One my sub id list (contract #) and the other is my product list.. There is only one line item--Sales. Time is on the pages (as years) for both,…
-
Column Alignment
Is it possible to set all column data to either right or left align?
-
Blank Data Field
Is it possible to have all fields blank until data has been entered into them? See attachment.
-
Dimension/Data/Storage
Hi Team, Is there any restriction on the number of dimenions/Lists to be created in Anaplan..? Can any one plaase let us know how is the data stored in Anaplan..? Is it in a file format or in a tables..? Where can i access the file or tables..? Thanking you in Advance Regards Sasi
-
User-based security access at the node level
I have the below requirement on user-based security access at the node level. I have 3 nodes (L1, L2, and L3) For example If L1= Americas L2 = Canada and US_Disti L1 and L2 will be my composite lists and we will have various attributes (KPIs) attached to them like Bookings or Sale proceeds etc. Now, If I am looking for…
-
User-based security access at the node level
I have the below requirement on user-based security access at the node level. I have 3 nodes (L1, L2, and L3) For example If L1= Americas L2 = Canada and US_Disti L1 and L2 will be my composite lists and we will have various attributes (KPIs) attached to them like Bookings or Sale proceeds etc. Now, If I am looking for…