-
Formula for blank value in lookup function
Hi I am using the below formula for one of my line item in my module 'Demand'. I am doing a look up in another module 'Open Qty by Bucket ID' by Bucket ID and SKU to populate the open qty value in the 'Demand' module. Open Qty by Bucket ID.Open Qty[LOOKUP: Bucket ID LF, LOOKUP: SKU LF] The issue I see here is,if there is…
-
Tableau 10.2 to make advanced analytics easier for enterprises
Tableau 10.2 adds advanced mapping capabilities that claims to make data analytics easier and more scalable for enterprises. Intro: Data visualization company, Tableau software, has announced the overall availability of its new version, Tableau 10.2. The organization states that the release includes advanced mapping…
-
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.
-
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.
-
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…
-
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
-
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…
-
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…
-
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
-
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…
-
Delete List Item Action on Dashboard
Can I publish a "Delete List Item" action to a dashboard? Thanks, Mark Peck
-
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:…
-
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 .
-
How to give selective access to Drill Down Function
Hello, Anaplanner 🙂 I'm conducting the implementation of ANPLAN. In this project, Many companies give their data (ex: Purchase order, Reply order, Inventory etc) to one ANAPLAN model. We collect the detail data and make dashboard by combining that. so we have to give selective access to each companies. (See Attach)I thiink…
-
Get prev year result
I'm quite new to Anaplan and I would like to know if this formula is possible instead of IF Current Month THEN Variable Name[SELECT: TIME.'Nov 15'] this IF Current Month THEN Variable Name[SELECT: TIME.'ADDMONTHS(CurrentPeriod,-12)'] Is it possivle and am I using the correct syntax. Chris
-
historisation of data
My client wishs to backup data and not loose it when the time periods change. To do this I envisage modules with not applicable time and containing 2 lists: one the months of the year, the other the sequential years that he wishs to save. My difficulty is to transfer the data to these modules. In the source modules, in the…
-
Transaction Roll Forward on a Custom List
Transaction Roll Forward on a Custom List
-
Formula for comparison of previous quarters and months
I am looking for a correct formula where, in a destination module, if I do a time selection on a specific month I get the periodic value and the ytd value of that month and the previous month. But in the same line item the formula should hold when I select a quarter. So when selecting a quarter it should give me the…
-
Error Loading Data
Hello All I have come across the following error ... while importing data in to a LIST _Error_1_New property combination found but name or code already exists Now i have been to the source file and done checks multiple time to see if there was any duplicates but there were none. I see this error as a there being…
-
Delta Loads
Hello Is Delta loads possible for BOMs data in Anaplan and if so what is the best way... Thanks
-
Date Conversion
Hi I am looking for a forumula that converts the year and week number in to a date format Example - 2015.01 converted to 1.01.2015 What could be the formula for this Thanks
-
Not a Parent function?
I have a line item with a list format where the items contains some parents. Eg. List contains Parent: Sector A with Child Material A, Material B and Material C Parent: Sector B with Child Material D, Material E I want to either 1) allow the selection to excludes any parent items, (Select Only Material A, Material B,…
-
Refer to Parent list
Hi, I'm new here and I'm not that experienced yet with Anaplan. My problem: I've created 2 lists. Prof_level5 tells me if it's a mortgage loans, consumer loan, professional loan or defaulted loan. Prof_level6 is a drill down of level 5, it contains for example more detail on the professional loans saying if it's an immo…
-
Format Line Item as Versions
I am trying to use a lookup based on month to return versions. We have 12 versions one for each month in the current year. I was thinking I would create a mapping table with months as a dimension and format a line item as version to use a lookup. Is it possible to format a line item as versions. If not, any other…