I am looking for a rolling function that calculates the total value of opportunities over the past 90 days from the current date. Any suggestions or formulas would help! Thanks
I have run into an issue with correctly mapping monthly depreciation costs to the periods within the fixed asset's useful life. Module A (screen cap attached) contains the user inputs for the fixed as…
I was reading this and on the EXAMPLE section, there is a IF condition as below; IF ITEM(Products) = Products.Widget THEN <... calculation for Widget ...> ELSE <... calculation for other products ...>…
Hi, I am trying to create a module (line item) from a list formatted as boolean. Does Anaplan have a built in contain function so that I can select the words that I want ? i.e. if column 1 contains "S…
Hi there, I would like to create two new items for calculating “Renewal Date” and “Renewal Qtr”. I am able to figure out the calculation of “Renewal Date” but not the “Renewal Date” into quarter. Sale…
Hello All, We have requirement where user will enter the numbers at Month level and the same has to be broken equally to the week level. All the rest of the data resides at Week level and hence the di…
Hello, Background: I have a numbered list with a property NLIST Name: Genera_Special PersonType <<Property Name John Doe General Bill Gates Special Joe Neighbor General Steve Jobs Special There is ano…
I have a requirement to show the following: annual quota * multiplier = target then compare month orders to this target and see if the person exceeded the target. I have a module at a monthly level, a…
Currently only when you use Time you will be able to use PREVIOUS() or alike function. These functions doesn't apply to Lists but at CBRE I have a case where do need a similar function. Today the SUM …
Hello, I've researched this topic but haven't been able to find a clear answer. I'm looking to create a headcount dashboard that tracks historical headcount by function over time (by month). It looks …
Is anyone able to describe the performance impact (if any) of referencing line items from other modules or lists which have the same relevant dimensionality? Particularly using SUM and LOOKUP operator…
I have a line item that contains the date in a Text Format(examples below). Is there a formula that can convert these numbers to a Month Format? 2018001 2018002 2018003 2018004 2018005 2018006 201800…
I would like to store last year actual value in version. So my version willl have Actual, Last Year and Act vs LY Variance. Can I achive it using formula in Version setting? Thanks and regards, Maung …
Summary: When building Anaplan models, the SUM function is used to add up values that meet one or more specific criteria. Find out how to construct a formula using the SUM function in this short lesso…
Hello. There is a list of numbers (not number list) - 1,2,3 etc. There are no other dimensions except this list of numbers. No Time dimension. There are 2 line item: Lead Column and Cost Centres Could…
I have a list with values in the format "<description>-<code>" (seperated by -). I am displaying that list in one column of a module as a drop down from where user can select. I need to change this fo…
We are trying to figure out how to delete a item in a list that is specified via the REST API. I have figured out how to create a control module that selects items in a list via a line item formula, c…
Is there any function in Anaplan to calculate Standard deviation. In excel there is a function "STDEV". Need to get the standard deviation for a product across 36months of data.
I would like to allow a model user to flag ONE member of a list as the "base item". If the user changes a leaf-level list item's "base item" flag to TRUE, then all other leaf-level list items that wer…
Dear all, We have a scenario which is to calculate the seasonality % based on the past 3 years' actual, and the seasonality is applied for the planing of the next four years equally. For example: FY18…
Hi, Can anyone help me out on understanding below formula what exactly it drives ? Import Rebate Actuals.Gross Sales Amount[SUM: Import Rebate Actuals Map.Reporting GroupProductCustomer List, SUM: Imp…
Hi, I would like to apply conditional formatting on a dashboard. I have a module based on 3 versions. -Actual -Annual Plan (AP) -Variance Variance = Actual - AP Now the conditional formatting should b…
Hi everyone, I'm having troubles creating a module that recalculates a regression each month. My regression is based on values of the last 12 months. When there are no 12 months of histicorical data a…
Hi everyone, Apologies if this has been asked before but I couldn't find anything in my searches. Is there no way to have a 'long date' format for days, eg: dddd dd,mm,yyy Thanks in advance! KT
Hi, I have a field that is a list format (itemcode), and it has a 3 letter code at the end of each item (e.g product1-abc123-regular-CNC). In another field i want to check this code before carrying ou…
Hi, I have a long list that has around 30000 line. soem of lines are duplicate and I need to deperate them. I wanted to use Rank function and group lines base on a property but I have 17000 actual gro…
I have a list of products and few of those products are new to the hierarchy with no history. In this case i need to compare and refer from SALES line item' of a different product from same list. * I …
I have a P&L 1 that has being data input into it using a list Organisation 1 as its hierarchy. I require the same data to be pulled into a similar P&L which is using a different list Organisation 2 as…
we have Excel Match formulas which looks thru a lookup_array 1) which finds the largest value that is less than or equal to lookup value (match type 1) and 2) which finds the smallest value that is gr…
