-
Circular References - CUMULATE
Hi, Anaplan is returning a circular reference eroor in the following circumstance (below are the line items - simplified); 1. Opening balance 2. Variable that depends on opening balance (1) 3. Cumulate of 2 4. Closing balance (sum of 1 & 3) - circular reference error message. Any ideas how this can be resolved? If I manage…
-
How to Apply two dimensions
I'm creating a scenario model which is based on two measures. I'd like my model to only apply a specific forecasted % to a row, if the measure is "total company" and profit share measure "Construction". However, I cant use the NESTED IF function which I would use in excel as its not letting me use multiple items on the…
-
Can anyone provide me an explanation of how calculation of numbers with decimals is being done?
I have been trying to sum up the decimal numbers in "Data" column , the column "indicator" is converting individual values from "Data" column into Text whereas "Bool" is converting the Summary of "Data" into text. Can anyone provide me with an explanation why I am getting a lesser value in Bool ?
-
Time List
Hi, I'm using week calendar type & using 4-4-5 for week grouping into months/qtrs in the model. So whenever i used month as a time scale in a particular module and tried to use month() function, it's showing peculiar values, as shown in the attached screenshots. Can anybody tell a workaround to fix this.
-
Date Formula
Hi, I need to get the number of days spent to finish a task. What I have is "Date Start" and "Date End", currently, in excel its a simple Date End minus Date Start and it will give the number of days spent. I tried to convert date to text or number, but it doesn't convert it that way. How can I do this in Anaplan? Big…
-
Time where a value is max
Hi, guys What I am trying to acheive is pretty simple as in the attached file. I would like to identify a month where "sales" is maxium among "TIME" dimension(Jan 2018 to Dec 2018) Any pointers? Thanks in advance Greg
-
Diagonal sums over flat list dimension on Anaplan
Hello, To put the problem simply, I need to know how to do the diagonal sums of an array in Anaplan. To explain in detail: I have a module called "Daily Matrix". It has the dimensions: Time, Days after Registration (a List, that "Applies to" the entire module), and one of the line items in this module is a "Daily Rate %"…
-
MAILTO should also use list formatted line item as a parameter
Currently MAILTO function does not work when there is a parameter (To,CC,BCC) with list formatted line item to select which email ID to select for email notifiaction. Currently either it must be text formated or hardcoded in the MAILTO formula.End user should be able to select the given list of approvers if there is a…
-
More granular forumula scope for versions
Description of enhancement: Ability to set formula scope for selected versions rather than just the limited options of All/Actual/All except Actual/Current. Business case: This would give us the ability to control what versions applied to a given formula. Would allow us to create snapshots. Would allow us to work in two…
-
Hide column time members without using Filter
Hi Experts, I am new to ANAPLAN.Please kindly suggest me .How to solve the below requirement The Requirement is like as followes, They are three Versions 1)Actual 2)Plan 3)Forecaste. I Developed Filter module.In Filter module we have plan,forecaste list items. user select plan version If Plan list item is 1 those columns…
-
How to override columns without using filter
How to override columns without using filter
-
How to hide column using formula
How to hide columns using formula and which formula to use. For example, if my column value is equal to 0, it should automtically hide those columns and if cell value if equal to 1 then it should display the values of that column.
-
SUM Question...
I need a hand on this, should be something easy, hopefully someone can help me. I have a LIST of 62 items (Products) These products has their transactional data in another LIST. I have a Module A with 4 categories of these items. 2 Categories are coming as they are in the Product List, the other 2 are determined based on…
-
Pretty Printer bottom when creating formulas
Hi, It could be very usefull if we had a pretty printer formula when creating formulas. I know we can check the formula indented when clicling on Drill Down, but it will be help us when we are developing formulas. Regards, Fayelle
-
How to give a group of dates as a condition?
Hi, I am trying to build a training diary that should prompt an error message whenever public holidays are being selected. For example , there are 10 public holidays in a year. I need an error message to be prompted while choosing any of the 10 days. How do I use these dates in my formula conditions? For example, the dates…
-
Text Calendar
Hi, Lets start with a picture I have a module with brands, promotions and periods and some text, and would like to present them similar to the above picture. I have not seen or used a module where text is displayed in periods, and before i started trying to work it out, wondered if there was any suggestions, advice or…
-
Anaplan function equivalent Excel MATCH function
Dear Anaplaners, What is the Anaplan equivalent function for the "Match" Excel function. I have a list "Age braket": 0 to 10 years 11 to 20 years 21 to 30 years Above 30 years I have 2 line items: Age : format number Age range : format: list "Age bracket" If "Age" is 25 , I would like to edit a formula in "Age range" with…
-
Formula to number a line item to create an order 1,2,3 etc.
I am creating a module that will be a template to import into our ERP. One of the line items is called 'Journalnum' which essentially needs to start at 1 and every line thereafter will be 2, 3 4, etc. E.g. in excel cell A1 is journal number 1 and cell A2 will be a formula to equal A1+1. There are 1000+ lines in the…
-
Display few months of data based on time selection
Hi All, I am working on particular client requiremnt. Where, the user dashboard has time as page selector (weekly format). Each time the user selects the particular week, I need to display that particular month and last 2 previous month data (not weekly). Note : In other words, I have a "movingsum" formula which is…
-
Year over Year Growth
Hi - I'm trying to calculate year over year growth in the time summary lines for my fiscal years. I can calculate year/year growth for each quarter (we are viewing our year by qtr only) using the offset function - (Revenue - OFFSET(Revenue, -4, 1)) / OFFSET(Revenue, -4, 1). However, Anaplan doesnt' allow the offset…
-
Simple Sum
Hi I have 2 modules, EPOS Daily Module which has EPOS data stored with a 'cust-bvfsku' and a date, updated on a daily basis. Then I have a top level module EPOS Sales List Module, which has a single line for each unique Cust-BVFSKU, and a start and end date. I want to SUM the p_unit Qty from the top module into P_Sales in…
-
Lookup Function -enhance this function with adding ability to ignore module's default dimensionality
Description of the enhancement required: Lookup Function - enhance this function with adding ability to ignore module's default dimensionality when using lookup. Pain - currently you cannot set another search argument instead of module's dimensionality, module's dimensionality is always used as lookup priority in Anaplan.…
-
Using a date range in a SUM
Hi, Module1 = dailysales has customer-product and date line items Module2 = periodsales has customer-product and startdate and enddate lineitems I want to SUM the sales from Module1 in Module 2 where the product matches and the date is within the start and end dates I can SUM using the customer-product :…
-
Lookup using another Lookup as reference
Is it possible to use a Lookup as criteria within another Lookup? Using Excel as an example; vlookup(vlookup(A1,B:D,3,0),Sheet3!B:D,0) I know the workaround would be to create a seperate list where the value of the Lookup becomes a reference use for another Lookup in a different list. However just wondering if it is…
-
Dynamic and/or breakback hold
It would be nice to be able to dynamically set cells on hold and/or set by default a hierarchy level on breakback "hold".
-
Hub Model Hierarchy Management (305)
This class gives the Anaplanner the fundamental steps to automate a hierarchy load from a Hub model to a downstream model. This training is intended for Anaplanners wanting to automate loading hierarchies/lists. You should have a good understanding of modules, views, actions, and processes before taking this training.…
-
Calculation Functions
Do not mark switchover automatically when creating a new line item.
-
Depreciation Using Profile Formula
Suppose materials are purchased in January, and then in another Line Item, I would like the materials to be depreciated over 3 months (spread that purchase value out over 3 months)? Which formula should be used?
-
TEXT function does not keep decimal comma format
A number with the format 1234,56 will be converted to 1234.56 when using TEXT function on a number that has comma decimal point format.
-
Admin rights need to be more flexible
As a model builder and Admin i'm frustrated by the lack of flexibility when it comes to admin rights. 1.) Admin rights should be able to be assigned per model not per workspace, this gives newcomers to the platform a 'safe space' to experiment with model building, writing formulas, inputting data and more without worrying…