-
requires cell info loaded in particular year
Hi All, I am trying to write an formula which should plot "year" info, where it was loaded in a list. This is about dates we manually loaded in a particular year. Now i want to extract the year info on the cell where this was loaded and not the year that the date mentions. For example we loaded 31-Dec-2018 in Year "2019"…
-
Hide Blank Rows
Hi, I have a module in which few rows have blank value with changing parameter. Can i put some formula or any way in which only the rows which are non blank will be displayed irrespective of there changing parameter?
-
Summing from week to quarter between timeranges
Hi everyone, I have encouterend a problem that keeps bugging me, so I would like to share this with you guys! In a model I have two timeranges: Model timerange: 2 years, months, no quarter totals. additional timerage "Long term": 5 years, quarter totals. Module A: Model timerange: Lineitem 1: timesettings: weeks Lineitem…
-
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…
-
Calculation of MODE in Anaplan
Does anyone know how to obtain the MODE of a set of values (in Anaplan)? For example, lets say I have a list of employees and each employee has a salary. I'd like to find the salary that occurs most often in a group (i.e. the MODE). Working with MODE in Excel, there will be times when a MODE value doesn't exist (because…
-
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 %"…
-
Anaplan Connect 1.4 Null pointer exceptions
I am getting NullPointerException errors from Anaplan Connect when I include -process -execute instructions. I started from the example.sh script. The process runs two Import actions that import from the same file, first into a List and then into a Module. Here is my script: #!/bin/sh # This example uploads a file and runs…
-
Best practice for Organisation Hierarchy in Matrix Style Business
Hi, My company uses a matrix style hierarchy where we look at client and country on separate dimensions as per the below image. I'd like to recreate this view in Anaplan (without the sparsity). Where client leads can see their client across all countries, and country leads can view their country across all clients. I'm…
-
Limiting on time selection
Have a module for marketing deals that have start and end dates inputted as weeks (eg W/e 19 Jan 2018), but whenever somone loads a new deal this defaults to the first week in the model, in this instance it's the start of 2016 which means a lot of scrolling / typing in the right date. Is there a way to have the drop-down…
-
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…
-
Values from multiple line items into one line item split by a dimension
Not sure if this is possible. I have multiple line spread across multiple modules. I want to be able to bring all the values into one line item in a seperate module which it split by a dimension reprenting each of the unique line items. So I have: Module 1 with Line Item A Module 2 with Line Item B I want Module 3 with…
-
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.
-
Changing Current year
Hi, I am working for a client for which we need to change the current year in time settings from 2018 to 2019. We have one future year and one prior year in the settings. I want to know whether updating the year will impact any structure of modules, reports, live model synchroisation etc.? or I am good to change the…
-
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…
-
How to get "hierarchyEntityLongId" (List id which appears if you copy-paste list format to excel)
Hi all, Excel is very handy for "mass" analysis/amendments of line items. However, for List formatted line items I get List ID (instead of name) in "Format" column. It happens both when you copy-paste or export blueprint for all line items. It is very annoying to manually map these IDs to list names. Screenshots are below.…
-
Module sparsity leading to size and performance impact. We are looking for alternative approach.
Dear community, I am having issues with modules I created to analyze the planning results. Due to the high sparsity of the data model, I get a lot of cell combinations, most of them empty but leading to high memory and performance impact. I will explain the model setup that leads to the issue, hoping someone knows how to…
-
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…
-
Limit on Input values
I want a certain limit on the total of my input data: * List of 5 products * Input Module in which a percentage can be inputted per product * The total of the percentages can't be more than 100% Is there a way to show a certain error message once the input results in a percentage of more than 100%? Thanks! Faas
-
Find date related to boolean line item
I have build a module with time over the columns and a flag as a line item. Now I want to extend this flag to an x amount of periods, starting from the date flagged in the current flag. In order to do this I would like to find the date attached to the TRUE value of the flag, then sum the amount of periods to this date, and…
-
Workflow email
Hi, Is it possible to customize the email template sent from the workflow view? Thanks!
-
How to run a process from another model?
The title is pretty self explanatory, but if I have model A and model B, is it possible to create a process in model B to runs a process in model A?
-
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…
-
Use three versions in model
Hi, I'm trying to build a rolling forecast model that has actuals, budget, latest estimate and forecast with the following dates: Current month = jul 2015 Budget = currenlty available for 2015, should be updated every year Latest estimate = sum of actuals and remaining budget in the current year (2015) according to the…
-
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…