
Calculation Functions
Calculation Functions
Discussion List
- Dear all, is there a function enabling to show the last work day (ending on Friday) of each month (date formatted), e.g. last work day of July 2016 would be 29/07/2016? Thanks a lot in advance for you…
- Hi, I have created a numbered list with list formatted properties. When using such a list in a module or dashboard, is it possible to filter based on these properties? Thanks Roger
- Is there a way to use lookup by display name? I have a numbered list List B which has parent hierarchy is set to List A I have set the display name instead of the code. Module 1 : Pivot has: Pages : L…
- How do I get the full name of the user in formulas? I have a module with owner data and i want to check if the logged in user is the owner of the data eg: I have a property called "Primary Owner" I wa…
- Hello All, I am trying to do a 'bulk copy' action to copy data from Actual to another version. However, even after I select the target version, the "OK" button is still greyed out. What might be the r…
- Hello, I am trying to figure out if there's a COUNTIF type of function that can be used in Anaplan. I have a line item that lists various years in number formatting and need to know, for example, how …
- Does anyone know how to calculate the difference of days between two days? For example, (4/1/2015) - (4/5/2015) = 4 Thanks!
- I was looking to count a list property text and come up with a numerical value total. In excel we can use countif, what can i use here in Anaplan?
- Hello, below my issue. I have a Module Product_FollowUp with product list and Time as dimension of this module. Inside the module, i have a line item "Assigned Resources" based on a list of Resources …
- Hi , Can any one please help me with the following formulas used in Rep Quota Moduel: Tenure Formula: IF NOT Active? THEN 0 ELSE IF YEAR(START()) ‐ YEAR(REPSETUP.Start Date) = 0 THEN MONTH(START()) ‐ …
- How do you write a formula that takes the UNIQUE count of values in the summary. For example: Product A: Rep 1 and Rep 2, Total = 2 Product B: Rep 2 and Rep 3, Total = 2 Product C: Rep 4, Total = 1 At…
- I have update the list with fake time periods, how do I use the timescale related formulae like next/previous etc in the module? cheers,ym
- The date formula requires you to use numbers for the years, months, and days. I have 2 line items in a module that have the year, and a custom month list that contains the members of Jan, feb, mar, et…
- I'm trying to find a "day of week" function. Essentially i don't want to count hours on the weekend. Any ideas? It seems like it should just be a formula dayofweek(start()) but i can't find anything l…
- In several cases I need to use a subtotal for 5 quarters in calculations. I have been using the All Periods total for most and it works some of the time. However, often I don't want values included fr…
- Dear Anaplanners: I have a question regarding usage of IF conditional statement. All the conditional constructs in Anaplan are related to IF with ELSE as a mandatory clause. However, I have following …
- I have some data as per below table. RevenueCountryNew bizJanFebRev aChinaY 3,000.00 3,000.00Rev bHong KongN 2,000.00 3,000.00Rev cChinaN 4,000.00 5,000.00Rev dHong KongN 2,000.00 4,000.00 I would lik…
- Hi, I have a list of deals which are imports from salesforce opportunities which I need two things done to. Firstly i need them sorted by the close date and secondly i need a cumulative sum down the l…
- Anaplan's equivalent of a COUNTIF function While Anaplan doesn't have an official COUNTIF function like Excel, you can combine an "IF THEN" statement with a "SUM" function to accomplish the same goals…
- Hi, I am trying to create a module that contains line items for Gross Cumulative Project Valuations. I need to be able to calculate the individual valuation (the current cumulative less previous cumul…
- Hi, I am working on a retail POC which is based on daily sales. The modules I've created contain a Day timescale which works fine. However, I don't seem to be able to create a Time Period Format that …
- Hello Anaplaners: I have a following questions - 1. Is there any way that lets me change the properties of a cell based on certain values? For example, If flag in cell A is set then I want to make Cel…
- Hi all... I'm a modeling newbie hoping an experienced Anaplaner can spot my mistake here pretty quickly. I inherited a model containing Module XYZ that contains a line item with the following formula:…
- I am trying to implement a ranking function which based on user selection of filter on a hierarchy list provides top 5 records i.e if he chooses the lowest level in hierarchy he gets top 5 results on …
- Does anybody has experience with linear regression in Anaplan? I also need to create a statistical model for detrending and deseasonalizing time series...any ideas? 🙂
- Hi, I am fairly new to Anaplan and I have a requirement where there are 2 models with a common text line item . I need to create a 3rd model by comparing these 2 models based on the text line item to …
- I'm trying to build an exception module to check that all items in a particular list with a particular property residing in another module belongs to a subset in the list. Is there any function like I…
- I have 2 modules, one having monthly line items, the other having annual line items. When I link the line item in the annual module to the line item in the monthly module, the full year figures come i…
- Is there an easy way to timsum over a module that has a time scale in quarters? I could do a work around and split it into months in another module but wanted to keep it clean. Quartervalue doesn't wo…
- What are the time periods that I can use select function for?