-
Limit Date Format
Is thier a way to limit the years that is available for selection when using the format line item as date?
-
Circular Reference with OFFSET function
I'm getting a circular reference while using the OFFSET function, but I don't understand why. (1) IF offset_value = -12 THEN OFFSET(Gross Revenue, -12, 0) ELSE OFFSET(Gross Revenue, -11, 0) vs. (2) OFFSET(Gross Revenue, offset_value, 0) Dimension is Months and 'offset_value' always equals either -12 or -11 based on a…
-
Allow selective updates on an input table
Hi, I have a module which i have designed for input. The module is based on Time (months) and Versions list (Custom versions not Anaplan built in version). The input module therefore looks something like this: Versions (drop down) Jan-18Feb-18Mar-18Apr-18May-18Jun-18Orders Sales Now i have another module which helps me set…
-
Reference one column in Module based on single dimension
Hi, I am stuck at a point from where i am unable to proceed further. I have a module "Module 1" which has one list as page, one list as rows and columns as line items. It looks something like below PageList 1(dropdown) Line item1Line Item 2Line Item 3 (Formatted as List 1) List2 1st value List 1 value 1 List 2 2nd value…
-
Formula for a specific cell
Hi, I have a module with 2 lists: currency (Local and GBP) and list item e.g. Expense. I input data into Local and Expense cell e.g. 1000. I want to calculate GBP amount of that 1000, by multiplying number in Local cell with FX rate. How do I write formula for the GBP cell? I find that I can only write formula for the Line…
-
Create a formula from text
I am trying to perform a lookup across multiple modules, but would like to avoid a gigantic case statement.I'll try to illustrate with this example. There is a list called details and a module called data. I'm trying to aggregate the data into a new module called summary. Right now, my formula is a massive conditional…
-
Linear Optimization Examples
No idea if this is going to be helpful for anyone, but it was helpful for me. It’s a basic 2 variable linear optimization question. I haven’t done a lot of optimizer demos, but I’m anticipating someone asking me “what is optimizer doing exactly?” This basic problem really helped me think about the madness Gurobi is going…
-
Optimizer Scale Limitations and Question
Hi all, I created a simple model for assigning sales reps to advertiser accounts. The reps list has a max book size and a max account limit, and the advertisers have a corresponding book size and account size (default 1). There's also a complexity and location property on both lists that have to match in order for an…
-
Display List Elements
Hi, When you export a module, you can choose to select any element from the source list, to display in the export. Can this be done in a module, so you may show maybe 2 list items? Module in Anaplan Module Exported to XL (with extra column shown)
-
Replace line items with line item subset for a view of a module
Hi, I have a module that consists of few line items. I want to create a view of this module with line items as a page selector but I want to show only a few line items in the dropdown on the dashboard. Is it possible to use a line item subset for only one view of a module? How can I do this?
-
Find an item from a list with a property that isn't code
I saw the post about Find List Item based on a property, but the solution was the create a number list where the property for the Finditem was the code. We can not have it as a code, and they have similar role ups so the can not both be used as dimensions on a line item. How can I find the list item?
-
Summation using Months and Year
Hi All I have a piece of data which is based on unique keys. Each key has data for multiple months. Also there is another column which specifies the financial year. I have created an intermediate module where each transaction for a key is flattened out by month. So i have line items which derive the month value in text…
-
Referencing data from one time range to another time range
Hello All, How can we reference data from a line item in a particular time scale to another line item with different time scale ? Like i have my model calendar as FY 2016. And i have added a time range as FY 2017. Lets say i have a line item (x) whose time range is same as model calendar, and another line item (y) whose…
-
Find List Item based on Property
This is probably straightforward, but I'm struggling with it... I have a module that includes historical department names, which are combinations of numbers and text, i.e. "5100 Engineering". Sometimes the department names change, for example "5100 Engineering" might become "5100 Core Engineering". I want to create a list…
-
Pull/Lookup data from general list into module with numbered list
Dear All, Appreciate if anyone can help me on this. How to pull/lookup data (properties data of Total Area sqf) from a specific general list (Detail Project Component list) into a module (Master Tenancy List) that contained a numbered list with parent hierarchy is Detail Project Component? If not using numbered list, yes…
-
Please allow expandable fields or a preview of content.
Hello, i can not find the section where suggestions are made but please please please can we do something about the inability to see details in a field. Example below, i am quite sure the customer is not importing from the same module to the same module, but maybe they are using a view, it is impossible to tell from the…
-
Sum to get total sales based on a GL Value by month
Hi, I am pretty new to Anaplan and i am hoping i can get help with a problem i am stuck at. Below is a mockup of my data Module 1Transaction 1Transaction 2Transaction 3Transaction 4Transaction 5Transaction 6Transaction…
-
Configuring a filter for nodal values
Good afternoon! Tell me, please, how can I implement the calculation of a formula related to text functions with ITEM on a node element? The problem is this: 1)Data HUB was configured, which forms balanced hierarchies (in accordance with the course 305 and this topic in the community). 2) In the basic model it was possible…
-
Automatic update of Current Period
Hi, this has been posted a couple of times before and I am not sure if this has been solved or not. How do we ensure that we have the time period updated automatically in Anaplan? Should we always do this manually every Week? Thanks Sidd
-
How to update Current Period automatically
Hi, Anaplanners I'd like to know how to update Current Period of Time setting. I change it everyweek by myself. but if possible, I'd like to change Current Period automatically. If you know how to set it up, Could you share ? Thank you for your help in advance 🙂 Regards, Hirokazu
-
How can I copy data from one module to another against hierarchy
Hi, I need help with something am trying to achieve in Anaplan. Module 1 Organization List (Organization Hierarchy is L1-Global->L2-Country->L3->Regions) Line Item: Volume Module 2 Organization List (Organization Hierarchy is L1-Global->L2-Country->L3->Regions) Line Item: Volume1 Line item: Select Level of Analysis…
-
Past 90 day functionality
I am looking for a rolling function that calculates the total value of opportunities over the past 90 days from the current date. Any suggestions or formulas would help! Thanks
-
Creation date for the record entered
Hello Need your help in finding way to populate the creation Date/time for the new record entered in the General List. Thanks Regards Prabakaran
-
When a data point extends beyond model's time range
I have run into an issue with correctly mapping monthly depreciation costs to the periods within the fixed asset's useful life. Module A (screen cap attached) contains the user inputs for the fixed asset including the depreciation start and end dates for the asset. In this module there are also two line items that use the…
-
Daily planning custom time scale
Hi Has anyone ever built a custom time scale that can handle days to day operation? . I try to set time scale for import inventory data in daily level. But model calendar cann't set into daily level. In the model , I need to display and calcutate for daily planning. Please suggest. Thanks in advance
-
If item is contained in list
I was reading this and on the EXAMPLE section, there is a IF condition as below; IF ITEM(Products) = Products.Widget THEN <... calculation for Widget ...> ELSE <... calculation for other products ...> This made me wonder, does Anaplan automatically compares each items within the list? In Python term, I am thinking Anaplan…
-
Alphabetize Lists
How can I quickly alphabetize a list?
-
Does Anaplan have a "contain" function for words?
Hi, I am trying to create a module (line item) from a list formatted as boolean. Does Anaplan have a built in contain function so that I can select the words that I want ? i.e. if column 1 contains "SKY" then TRUE else FALSE Thank you!!
-
How to create "One employee reporting into two managers" as a list(hierarchy)?
Hi, Is there a way to set up a list (hierarchy) in Anaplan when the hierarchy is built the following way: One person and two managers. ManagerEmployeeLowest level in the HierarchyManager AEmployee ACost Center A Manager BEmployee ACost Center B Any help is greatly appreciated! Thank you.
-
How can I copy data from one module to another
Hi, I need help with something am trying to achieve in Anaplan. Module 1 Organization List (Organization Hierarchy is L1-Global->L2-Country->L3->Regions) Line Item: Volume Module 2 Organization List (Organization Hierarchy is L1-Global->L2-Country->L3->Regions) Line Item: Volume1 Line item: Select Level of Analysis…