Modeling

Revenue and Expense eliminations in reports
I am creating a Income Statement where I would like to see a column for eliminating intercompany activity. Has anyone built a report or module that handles eliminating accounts?
How to reduce the dropdown list of a column
I have graders name as a column in a module. The column datatype is a list (graders name) I want to reduce the dropdown from that column to only active graders ---- I tried creating a subset of the list (graders name) and then using that list as a datatype in the column but that erases all the data related to previous…
filtering
Hi, Please see details on the attachment. Regards,
Edition Compatibility between SQL Server 2012 “Evaluation” Edition and “Enterprise” Edition
Hi all, I'm Newbie to SQL Server 2012, I found out that there are paid and free editions of SQL Server 2012 available . those are 1.Enterprise [paid] Tableau 10.4 B.I [paid ] 3. Standard [paid] 4. WEB [paid] 5. Express [free] 6. Evaluation [free] 7. Developer [free,paid] Now I have ambiguity between paid version and…
Incremental Load
Hi, How incremental load works from data source to data hub ?
Ability to view a module side-by-side with it's Blueprint mode
When model building I find myself regularly want to see a module AND it's blueprint mode simultaneously so I can scan formulas, change things in blueprint, and immediately see the effects without having to toggle back and forth. This would be like using split screen in Excel to compare two workbooks side-by-side Toggling…
Format checker
I want Anaplan to check if the FORMAT of my line item correspond the the formula i'm entering BEFORE starting the calculation and if the format doesn't match the expected result, i want Anaplan to hold the calculation until i can change the format to match the formula results.
Delta Load
Hi, How incremental load works from any data source(other than anaplan) to data hub in anaplan?
Copy/Import Line Item Formats
To provide self-service modeling we need to allow users to not only add new line items to a module but also to change/update the formats. It would be nice to be able to import line item formats as well. Line items can be imported but then only a model builder can change/set the format. For example: I want to give my users…
Sum by Account starting with specific number
Hi, I have a List with accounts starting from 4* ,5* and 6*. These accounts have some data value against them,I want to Sum up the data value by 4* ,5* and 6*. Regards Madhu
Unicode References
HI Folks, Can we use Unicode Characters in Anaplan? As of my knowledge, we shouldn't use as it might reduce the performance of the model. Is that true? (I have access to One APP which itself built by Anaplan and I can see Unicode characters over there) If we can use it, can someone give or suggest the source where to get…
Pricing of Products with semi finished goods
Hi, How pricing of products for one plant can be used as semi finished goods for other plant with updated cost of product as raw material cost for the next plant. Please provide with the solution for designing the same. Thanks Pujitha
FINDITEM formula
Hi Can we use time rang for finding time period while using finditem function. Thanks & Regards Keerthi
Update Codes in a numbered list
Hi, I've set up a numbered list with an name property. The formula comes from a module - it should update the numbered list as well - any idea what I'm missing. Thanks.
Import from module with greater dimensionality
Hi, I'm attempting to import data from a module in another Model (monthly employment costs per employee) which has greater dimensionality than my current module (The source has a Currency List & also Versions which the current Model does not have) Is there a way to SELECT a Currency List & Version item to import or do you…
Anaplan history not updated correctly
Hi Experts, We are using the Anaplan model from the last 3months. Now, when I check the history I am not able to see any history of the model. Is there any setting for showing history in Anaplan ?? Please help me with this. Regards, Uma
Import data to a module - have code info in file but List has code description
Hi, I want to import data into module which has Account list, where Account list has code-description format Example '1000004 - ABC' My Source file has account code only with balance. i,e Account Balance 1000004 200$ while importing source file unable to map account code with account full name in list. Note: This is not a…
How do I sum across dimensions other than time?
Hello Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against every product. 0x80070490 Beyond allocation use, is there a way to introduce a line item that returns the value at the next…
Fiscal Calendar Lookup
I am trying to lookup (using the lookup formula) the fiscal year, fiscal quarter, fiscal period and fiscal week using the date an item was sold. We have a calendar module that contains all of the conversions (date, FYear, FQuarter, FPeriod, and FWeek). Sales are tracked using Fiscal Week End Date so my formula for fiscal…
Extend Date format to include Time (hh-mm-ss)
Description: Being an Anaplan Builder, I would like to be able to have a date format with Time in it (hh-mm-hh) Some of our planning tasks are connected with work with exact timing (Date + Time). Currently, we have to upload this data as text and use RIGHT(),MID(),LEFT() functions to extract values. If we have a customized…
Month to Date Formula
Hello, I'm trying to use month to date formula. It doesn't look like it's working correctly. cumulative amount should never decrease if i'm adding values month on month. Thanks
Is it possible to override a formula in a line item? If not, how can I enter a starting amount?
I want to be able to enter a starting amount and from there on have a formula driven on the line item. Example. Beginning ARR manual enter amount in Apr, then it will drive the calculation to get the ending ARR. The beginning ARR will equal to previous months Ending ARR. I included several screenshot. The excel file…
Project Planning v.1.2.3
Hoping to see if anyone has created a simple project plan . Task/Start/End/Owner/% complete in the Project Planning Model. When I start the process I get the below error. The list specified as the page selector is empty so there are no items to select. Ask your workspace administrator to add items to the list or remove it…
Defaulting values for line-items (vs. modeling via override)
Abilty to have by default a 100% value in a line-item vs. modeling this behaviour with a line item of 100 and putting an override if you do not want 100% (e.g. redemption rates). The default should be able to have a formula behind it. (cfr STET functiona in competitive products) Benefits : 1) Huge UX improvement on…
cell security change for model builder
Hi All, The cell security is a great feature, but I find it a bit confusing that as a model builder you are able to upload data where a normal contributor is not able to upload data. This makes it more difficult to test solutions, because the model will behave differently if you are a model builder versus when you are a…
Applies To for a module - would be nice to have a search option
Description of the enhancement required: Creating Modules or adjusting the "Applies To" it would be helpful to have a search bar/button. A story for why they want the enhancement, (how would it help their business process): In case you have a lot of lists, it becomes very inconvenient to reapply the module. This change…
Display the Action IDs in Actions list
Description of the enhancement required: Display the Action's IDs in Actions list so that Interface (Anaplan Connect or Rest API) can work with action's IDs (not with captions (Action Names)) A story for why they want the enhancement, (how would it help their business process): At the moment, to refer an action by ID we…
Increase the limit of characters in Notes section
HI Team, It would be really helpful, if we can increase the limit of characters in Notes section of a module. Currently it has 250 as a limit. I got stuck here when I tried to copy paste one lengthy formula cos I don't want delete the formula instead I might take that for my future reference. Let me know others thoughts on…
Weekvalue formula
Hello, I'm trying to pull weekly data into a module that is based on months. I've tried to use the WEEKVALUE formula, it returns 0. My source data has a week value assigned to it. Thanks Hina
Exclude Zeros From Average
I am calculating an average but I do not want the zero values to be included in the average. How can I exclude them?

Modeling

Discussion List