Modeling

Help with NPV Function: Anaplan differing from Excel
I am having trouble with the results of the NPV function in Anaplan versus that of Excel. In anaplan, I cannot control the scope of the time periods being passed into the NPV function. I am expecting a value beginning in Q2 FY18. However, the calculation returns a value beginning in Q1 FY17. My client is expecting the…
Profile Example
Can someone provide the example of using Profile function in Anaplan, I need to spread the value between two dates? for eg: Start date 1/Jan/15 to 1/dec/2015 - value is 12, spread should 1 each month. regards, yagna.
Turning the status of subset list ON without import
Hi, In a module with the dimensions of product list which has a subset and line item of sales amount, only if the sales amount of a product item is not zero, is it possible to turn the status of subset list ON not using import function? Thanks and regards, Maki Yasuda
Load Data To Anaplan
Hi, I would like to understand if we can pull the data from an Oracle Database to Anaplan by writing some script. When I was reading about the Data Integrations it doesn't talk about Oracle Database. Am I missing any link to look at? Please share some information on this! Regards, Raghuveer.
List subset by formula
Dear gurus, I'd like to create inventory report and included "Item master" as dimension. However, since there is no stock in 50% of item master, it is obviously waste of cells. So, I'd like to create list or list subset based on "existing stock only". One of idea is to create simple module with item master, and…
how i calcuate duration(in months) between two months
hey, i have an issue that is related to calculation of month. actually my line item which name is start month and End month that format is month(year). so with this how i calcuate duration(in months) between these Months. With this post i am attaching Screenshot Of Blueprint of my module.
Ghost Models?
I don’t think I can see all the models in my workspace and I am a workspace administrator. Is it possible there are older models from former colleagues that I cannot access live in this workspace? Is it possible to somehow made all the models accessible to me, so that I can review them and archive or delete?
Leveraging Excel File with Formulae
Hi all, I am in possession of an Excel file which for the purposes of documentation, has a list of all accounts and their respective formulae. For example, a line may have: Name: Code: [OpStatement100] Formulae: [Opstatement50 x Opstatement75] (anything within square brackets is the literal text of what is withing the cell…
Child to Parent Ratio based on Planned Input Number
Hello I have a set of Actuals(FTE) by Level 3 rolling up to a Level 2 in turn rolling up to a Level 1. I need a formula that calculates the ratio to its immediate Parent first . I also am looking for a mechanism where someone enters a new value at level 2 (immediate parent) the new planned numbers for service level 3…
Demand Planning
I am looking to build a demand planning app and had decided to use the Statistical Product Forecasting app from the App Hub. However all the data is only in monthly buckets. My process needs to have weekly data and forecasts. I have looked through other available apps as well but any app that does forecasting seems only to…
Yearvalue and select
Dear all, is there somehow the possbility to use the yearvalue- and the select-function together? I want to transform year values to a monthly schedule and thereby just select a certain case from a list. Thanks you all in advance, Best regards
Copy month data
Dear, I have two questions regarding an implementation I'm currently working on. To give a little background information, it is a financial planning model for the coming 3 years and has a budget version and 4 different forecast versions. My questions are the following: [list=1] * Copy data from one month into all months* I…
Semi solution
I have been thinking about the issue and I found a solution, however to keep it feasible with formula's limiting the IF-function, I need a bit more help. Currently my solution is to recalculate the percentages in the final module, however I need IF function for every line item, as all of them are calculated differntly. For…
Synchronization using ALM
Hi, I want to move a structural change (adding properties to a list) from one model to another using ALM features. I'm not sure how to operate that, so are step-by-step instructions and screenshots on comparing & synchronizing available anywhre in anapedia? It would be very helpful for me. Thanks and regards, Maki Yasuda
Salesforce Connector
[img alt="Harisha.Mo" height="40" id="_x0000_i1025" style="border-radius: 5px; height: auto; line-height: 100%;" width="40"]http://www.gravatar.com/avatar/8794d4330529f879433f7490a8f5c294?size=40&default=https%3A%2F%2Fassets.zendesk.com%2Fimages%2F2016%2Fdefault-avatar-80.png&r=g[/img]Hello, How can I add a Salesforce…
Merit Increase Formula
Does anyone have formula string they like to use to calcualte merit increases in a specific month? As an example, if my merit increases every March, I would want my wages line to increase automatically by a % every March.
Compare Display names of two numbered lists
I've two numbered lists Numbered List 1 (storing a set of product codes) and Numbered List 2 (storing another set of product codes). - Product codes are stored in Display Name property Two modules - Module 1 based on Numbered list 1 and Module 2 based on Numbered list 2. In module 2, I've a line item which needs to check…
Filter on specific text in text formatted line item
Hi, I'm trying to filter on a text formatted line item. The source of the text is from another module through the textlist formula. In the text formatted line item there are several descriptions of transactions and I need to filter some words out of the string and then use the result to predict descriptions for…
Salesforce Native Integration Module Import
Hello, Has anybody had success using the Salesforce Native Integration to import data directly into a module? We have successfully connected the integration and can import data into lists, but not modules, just wondering if anybody else has tried this and if it is a platform limitation or something wrong with our setup,…
Integration with Microsoft Access Database
Hi, I need information on how Anaplan can be integrated MS Access for importing & exporting data to lists and modules. Also, need information on how the same can be automated based on certain triggers or on the click of action buttons. Thanks, Aseem
Comparing Line Items which has Numbered List Format
Hi, How can I compare two line items of two different modules (Format: Numbered List)? How to check whether a single entity/ entry is present in two Numbered Lists? (Both lists are Numbered Lists) Thank you
Conditional Formulas
Hello, I am attempting to make my budgeting model easier to roll out to every country my company is located in. To do that, i need to make one page where all the settings are per each location (for example: taxes for specific locations/countries, location specific benefits, etc...). Bascially I want this to look like is…
Anaplan Error for Assign Action
I am trying to Assign Support to another individual for quota purposes. When I run the action, I keep receiving the error: 'Model commit: cell reference is not writable.'. This only occurs on this one level but not any of the other levels (they are currently working). Why would this error appear for this level and also…
Delete List Item Action on Dashboard
Can I publish a "Delete List Item" action to a dashboard? Thanks, Mark Peck
Open a Different Dashboard Depending on List Property
Hello Fellow Anaplan'ers ! I have a requirement wherein I need to open different dashboards with the same action, based on list property. I use the native functionality provided for this; however for all different values of the list property, the button opens the default dashboard instead of the relevant dashboard. I also…
Product Hierarchy
Hi there! We have one prod hierarchy but we would like to introduce a new one that is linked to the top level but splits afterwards. One business unit should be able to see the other and vice versa. Currently, we have : -All products -Commercial Business Unit ---Prod Line -----Prod Fam ------Prod Sub-Fam -New BU ---Prod…
Data not clearing out
I have an issue with a decimal showing up in a formula that's supposed to generate 0. Line Item A: 48250.4 Line Item B: 65810.4 Line Item ClearAB: A+B-45250.4-65810.4 yields 0 Line Item ClearABAlt: A+B-(45250.4+65810.4) yields 7.275957614183426E-12 All items have same numeric format.
Issues with the Summary
Hello, I am having issues with the summary. I have an item that multiplies a tax rate, this taxe rate is unique per subsidiary, but when i select the total subsidiaries level, the multiplication instead of taking the rate assigned to its subsidiary takes the sum of all the rates. An example: Subsidiary 1- Amount: 100 rate:…
201 Delete dates for new hires prior to exam
The Training Guide instructs you "If you’ve added any new hires delete their start dates" prior to beginning the exam. Does this hold true for the two new-hires we entered in Activity #21 where we added Julie Mitchell and TBH? Thank-you!
Selection of Version used in Module
Hi All, Does anyone knows how to select the current version being selected(not the one which is marked as current in VERSION) for the particular module , which is selected .

Modeling

Discussion List