-
Retrieving last date with value
Hi, I have a module where I have time as dimension, as well as a list of equipment. The module is on daily level and has a value of either 1 or 0 depending on if the equipment is in service or not. These values are imported from another Anaplan model. I then have a second module, where I have the same list of equipment as…
-
Function for Format Conversion
Hi all, I just want to share a simple table as a summary of the functions needed to convert data across formats in Anaplan. Is not a big deal, but I hope it comes in handy to some of you. * Transform Text into Date is not that straight forward since it is needed to chop the date in 3 chunks: the day (DD), the month (MM)…
-
Non Parent/Top Item List Relationship
Hi team, I have a Currency list that has no parent/top item & an input module whereby the user will enter the data into the Currency dimension. In a secondary module I want to convert all those currency values entered by the user into 1 currency. I can only get this to work at the moment by not having a currency in the 2nd…
-
How to apply sum function(or any) on time line item?
Cee-Cee shop module is where my Spool & Cages incoming, Outgoing happens In Cee-Cee shop module i have Expected Cee-Cee return date which is nothing but (Date + Lead time days) Now in Expected Repair item return module, I have expected line item - What I'm trying to do is or requirement is to take from the incoming(Cee-Cee…
-
TIMESUM with Generic Weeks, and other summation options
Hi all, I thought I'd just summarise some of my learning experiences with summing data using Generic Weeks, since I couldn't find an article that brought this all together. First up, as you will probably know, you can't use the ordinary SUM function across the timescale if you've chosen Generic Weeks, as there are no…
-
Order of Lookups and SUM in formulas
Hi, I was going through a best practice video which mentioned that the order of lists in the module can help improve the performance if the lists are ordered similar to their order in General Lists section (because indexing becomes easier for the engine). I was wondering if there is a similar best practice when it comes to…
-
how to truncate concatenated strings with a separator
Hi guys, Assuming I have a concatenated strings with different length but with the same separator.. To illustrate: I have company code+ledger+asset code but with "-" in between.. This 3 do not have the same length.. Assuming here are my data 1. 111-123456-12456 2. 1111-1234-124 3. 11-12345-234 How can i get the mid…
-
using lookup formula, it works, but shows the result as 0
hey I'm doing a lookup off the employee drivers by role module and employee details module to calc employee expenses, but returns a 0 for the result, anyone have insight on this?
-
Pulling data from numbered list into a module
Hi All, I need some advice/guidance. I'm building a tiny model that looks at the number of components used in products. We have one component that can be used in 5/6 products. The end result that I'm trying to achieve is a module that shows me data by components. What I've done is created a numbered list called "infeed…
-
"is first occurence" gives me unwanted output. cant find a solution
Hello guys, my colleagues plan on IDs. After they are finished with their planning I want to build a profit and loss hirarchy by creating codes based on different inputs. Those codes have to be imported into a list. The problem I am facing now, is that they can plan totally different topics on the same ID in the next…
-
Level 2 Model Building: SYS08 Incorrect Data Population
I encountered an issue with my SYS08 module in which the data isn't being reflected the way it should. Products are not correctly population under their parent, instead they are put in at the bottom as shown in this screenshot: This leaves the "parents" blank: I have tried rerunning processes 1 and 2 (responsible for…
-
Pie Chart to Dashboard
Hi All, So i was trying something and i need help in that. In Anaplan, we create Landing Dashboard there we usually have a sequence in which the dashboards will be used by user. (Basically a process or steps kind of thing) Now on my landing dashboard i have 5 dashboards named DB1 - Step 1 DB2 - Step 2 DB3 - Step 3 DB4 -…
-
YoY Change % to forecast a line item from actuals
Assume, I have the following line items using which I am trying to build a prediction/forecast for "Revenue". Revenue --> Actuals are imported for the actuals period, and this should be the forecast for the forecast period. YoY Chg% --> Imported input data that tells the % change in Revenue YoY for that month, for the…
-
Period on Period % Mvmt - Formula Summary Method
Hi Team, I'm attempting to create a Period on Period % movement in a module using multiple dimensions but I require the summary level/top level to still calculate using the formula rather than Summing all the lower node %'s. When I change the Summary method to % I receive an error I have tried using Period, Lag & also…
-
How to decide whether to build a New Model or add the new functionaliy into an exisiting model
I am about to start modeling our Sales Commission Payments process, but I am wondering whether to build it as a stand alone model or add the functionality within our existing Operating Costs Model. The Calculation for the actuals (which is the part of the process that currently exists) will work of a set of lists which are…
-
Extract FY from Date
Hi Team, I'm trying to extract the FY from a date. In our world the Fiscal years run from July to June & hence 1/07/19 would be FY20 I could convert the date to a Time Period & have a separate module that maps the Time Period to FY but I thought that might be overkill? Many thanks Mark
-
Displaying the first date of my historical years
Hi All, I was wondering if there is a syntax that gives me the first date of my historical years, based on the timescale settings. My Fiscal Year (currently) goes from 01-06-2018 to 31-05-2019 and I have 2 past years within my model, i.e. the date I'm looking for right now is 01-06-2016. I would like to have a syntax that…
-
Formula to populate time period formatted line item
Hi, I have two line items - Year and January - with no dimensions. Year is time period (year) formatted and a user selection January is time period (month) formatted and I am looking for a formula which uses the year the user has selected to return the period - For example, the user selects FY19 and the it returns Jan 19.…
-
Time Setting - Tertial date formatting
Hi, I have a case where I am not going to use quarters, instead I need to split the FY into 3 periods (consisting of 4 month each/ tertial). Does anyone have experience with this and, can recommend a way to set this up? Regards, Stig
-
Versions of a list
Hi, Recently started using Anaplan for our annual business plan. Now we want to start our forecast and have come across an issue related to lists. Example: We have an Cost Center list and an Employee list that rolls up to the Cost Center list. For the PLAN, we have 2 Cost Centers and 2 Employees Cost Center 1 is the Parent…
-
Truncate decimals but not round
Hi All, I want to truncate the decimals from a number like below but do not want to round it. 2.22939393 -> 2.229 2.22977777 -> 2.229 2.59999 -> 2.5 instead of 2.6
-
GL code mapped to COS and OH's
Hi All, I am trying to import actuals using GL mapping into a P&L module ( Target). The issue is some GL codes map to both COS as well as OH's. The source module is dimension-ed per below: One of the stations is a dummy airport and holds all overhead costs. So for example, GL 01 relating to expense A is imported correctly…
-
Actuals not pulling through
Hi All, I am trying to pull actual values into P&L module using a mapping module. However the values are not transferring across. Details: I have created a line item sub-set from P&L module, which is dimension-ed by time and versions. P&L module Mapping module I have also built a mapping module to map the GL code ( List)…
-
Dynamic Names for Numbered Lists by User
So, I have attempted to explore the concept of allowing users the ability to change the property that updates the display name for a numbered list, and I can't quite figure out how to make it unique to each users' preference. For example, I am looking at a hierarchy and I want to know how the people roll up then click a…
-
Get data into List Property from another List
Hi, I have 2 LIsts, Numbered List and Flat List. I need to Pull Data from Flat list to Numbered List using Formula. For Ex: I have Emp ID Data in Flat List. I need to pull that data to Numbered List Emp ID property by using Reference and Formula. I tried but Not able to get the output. Can anyoune help here to get the…
-
Level 2 Sprint 2: Detailed Demand Review Dashboard
Level 2 Sprint 2: Detailed Demand Review Dashboard: In this exercise of building Detailed Demand Review Dashboard, are we supposed to match exact number shown on the activity? me and the 2 other colleagues don't seem to have matching numbers
-
I need some help on formulas and functions in anaplan where can I find some relevant material
I want to practise formulas and want some deep understanding
-
Variable results on dashboard depending on user selection
I want to present a dashboard where the information displayed varies depending on the year/version the end user selects - see attached picture of example. The modules that lie behind this example would be as follows: Input-Module 1 Input Cost - user input (Dimensions - Location List, Version List, Year) Calculation-Module…
-
Optimizer Constraints
Hi, In the constraints we specify for optimizer, the last constraint has the format of a - b =0, why is a=b not possible in the constraints. If we change the format , the process will be incomplete. Why is it so.??
-
Concurrent Planning
For a client we're facing issues with user dependency whilst filtering on the dashboards in Anaplan. We're using a Module with 10+ List-formatted line items to let an end-user select different combination of filters. However when multiple users are using the same dashboard which is based on one module/dataset their actions…