
Calculation Functions
Calculation Functions
Discussion List
- Hello, I am having trouble pulling the Baseline Volume calculation for the Supply Chain model in Sprint 2 of the model builder trainer. I have created the following calculation and get the attached er…
- Hi, I am currently supporting a project Budget Run and I come across a formula in excel where I thought was easy and yet kind of confusing. See on the attachment. I am trying to calculate the Recogniz…
- Hello, I am currently trying to calculate a future trend based on actual historical data and was wondering if someone knows of a function or formula within Anaplan that works best for this? Thank you
- Hi everyone, first post and hoped that someone could help me as I have been racking my brains to try and do this So I have a list which is called tbl_masterdata, within this list is a field called BVF…
- Hello, I have some questions regarding allocations. Hope I can get some advice from you. Thank you so much in advance! Here is the background information: * Source Module: Flat file without time dime…
- Hi Anaplanner, I have module like a picture In module Final I'm using list level 3, and I give user selective access in level 1(Indonesia), and in the module group amount I take amount form module fin…
- Hello, I have some questions on one of my models. Hope you can give me some advice. Thank you so much in advance! @DavidSmith Here is the background information: 1) Source Module: Flat file without ti…
- I am trying to pull non numeric data through from one module to another. I have found that "If your mapping table contains the Source List and maps to a Target List-formatted Line Item or List-formatt…
- I have imported my transactional data as a flat table using a numbered list. Something like this: I want the user to go into a second module where they can select drop-downs for City, and it will sum …
- Hi there, Just checking if any update an be applied to this challenge! I have a Masterdata list and module, that has 200 fields, of which 20 are Primary, 80 are Secondary and 100 are tertiary. When a …
- Hi All, Hope you are having a great day so far! I have a requirement to rank projects based on specific criteria of Profits from each of them. However, they need to follow a specific order to be consi…
- Within Q1, January is the first month (1), February the second (2), March the (3rd). Then Q2 starts, and April is the first (1), May is the second (2), and so on. Is there a good way to set something …
- Hi, I have a module that displays our full Masterdata list, with 3000+ products. I have a search module with some of the fields (12) from the Masterdata module. Allowing the user to narrow the list do…
- Is there a clever way to SUM on an item's attribute when that attribute varies depending on another list? I have two very large flat lists ... Items and Groups .. and another small picklist, Operation…
- I am trying to build a formula to pull in fringe benefit rates based on the department/unit and employee works for. I attempted to build an IF Then formula but Anaplan keeps telling me it is invalid. …
- Hi, We have a module , need to clear data from the module based on Period selection but one more than period should be selected at one go. One possible option is to copy zero value from a second modul…
- For example, my entity list has 4 levels as follows: Country->Zone->Region->Area->Branch and it is a production list. In this case, how can I use the different formula for each levels? I understand th…
- Hi All, I have a request to load a file to a master list and module, but prior to run this load I want to see what are the delta changes coming in the new file. So, I thought to park the new file in a…
- Hi, I have a module A with List A, and Module B with List B. Both the Lists are almost similar. But they are 2 different List. I have line Item PARENT_NODE in both Modules. I have new Line Item compar…
- Hello Everyone, I am trying to use Anaplan to view my data in tables but not lucky. Is there any way to obtain the data from Anaplan and see them in Tableau? Already tried a lot but no luck. Please g…
- I need to create a filter that pans across three dimensions. I've tried using a boolean box, applying that to the lists I need to select. I think I'm going about it wrong. Essentially what I need to b…
- Hi, I have created a module that contains detailed actual transaction data. The module is based on a transaction ID list and properties like month, account and cost center (and other details). That mo…
- Description: Allow OFFSET to be used on summary line item formatted as Formula. Impact/Benefit: I am trying to calculate a percentage change from prior year or prior quarter at the summary level. For …
- When entering the formulae below it works,however if i change the -1 in the OFFSET formulae to point to a lineitem to pass the no of periods to offset it is formatted as a number anaplan gives an erro…
- Hi, All I am struggling with retrieving a display name of a numbered list in a Property. My understanding is that Name(Product) will retrieve #1, #2,,, in my case. Could you give me some pointers ? Th…
- Hi Community, I've tried to post the same query yesterday, but it seems it didn't go through. I'm gonna have another try. I'm working on creating a Variance Dashboard at Cost Center / GL level. Having…
- Im creating a Rostering model in which I need to do the following: 1. In a module contain all employee information i.e.. start dates, shift pattern category, etc 2. Module containg a shift pattern pro…
- When creating a module with a hierarchy dimension, if the code is used as a line item, the code will display as blank for higher level nodes in the hierarchy. This is not the case in the list screen f…
- Would someone explain why Anaplan is giving me a number 5x larger than the number I am dividing when my calculation takes the first number (4,221.43) and divides it by 0? I would assume that it would …
- Hi Team, It will be great to have an option to select the Line Item which will be taken as a source to calculate phasing for Breakback function. At the moment split is done based on the items, in whic…