
Calculation Functions
Calculation Functions
Discussion List
- Hi, I'm trying to get the Average of the LI "Principle Balance" by two list Items names "Turn" and "Vintage". I'm not sure if I would use the AVERAGE function in Anaplan or a TIMESUM function. This LI…
- Hi everyone, We have list of Activities that are being uploaded in a numbered list with Activity Description and Expense Group as Unique Properties. Requirement is to generate Code in Anaplan based on…
- in sprint 3, i have been tasked to create a country summary output module with G2 Country and P1 product family as dimensions and stock safety flag count as line item. The line item will take data fro…
- Hi, I have the 2 modules below and did a lookup function but it returns blank values. Am i missing something?
- I am working with a system that calculates what payments should be, then when the actual payment is made we record what that value and save it back into the model. Sometimes there are retroactive chan…
- What are blocks? How blocks are calculated – General Lists How blocks are calculated – Native Time/Native Versions Hyperblock performance Summary block counts Should I worry about blocks? A reason why…
- Hi, I am trying to create a DCA where in the requestor should be the only one to be able to Submit a request. In this example for this module, I am logged in as user id Camille@abc.com. since the requ…
- I want the Repair and replacement = Flat terminal then 1 else o (or) True else false No getting the result
- I am Having two list formated line item, NOw i want chek true or 1 base on the one list item to other list item how can i acheive that
- Hello fellow Anaplanners, I have a query, I was going through an existing model and where I saw there are multiple composite hierarchy built having just 2 lists. i.e one is parent list (say 'X') and a…
- Hi all, I can see that there's a statistical forecasting App on the App Hub that can be downloaded but it looks like everything is in Classic dashboards. Does anyone know if there's a version of the a…
- Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get t…
- Hi, I have a module where users create New Cost lines. Since the security is based on Groups, users can see costs created by other users within the group. Now the ask is that users should see the cost…
- Hi I have an Emp List. An employee can have 2 records in the list (the 2nd one with an extension ABC OR). I need to pull the values of the 2nd record in another line item of the 1st record. Could you …
- I'd like to know the difference of Summary settings combination in the blueprint view between: Summary- Formula, Time Summary: Same as main summary vs Summary-None, Time Summary: Formula If possible c…
- Hi, The above are currently in the system where L4 is a list of distributors. I do not want to touch/amend since i am new to Anaplan and do not want to mess up anything. I created a new list as below;…
- Hi, i'd like to ask about how to apply different formulas on each item in a list. As You can see, Module 1 shows actual data from the current month. Module 2 is a forecast module, where the baseline c…
- Hi! Not sure if the subject header make sense but here it goes. I have a existing module that have pricing by distributor by month by SKU, example and lists used as below; Different distributor will h…
- Hi, I'm trying to convert Open date line item- text formatted in to Date using Date function but getting blank in Date Final line item, could you please help me where I'm doing wrong
- Drilling down gets exhausting. When you are in the module tracing a formula, when you click the chevrons to bring the formula window to the bottom of the screen, functionality to be able to right clic…
- Hi, I have attached a sample Modules that I have in my model: I want to retrieve the Quantity data from Module 1 to Module 2. but they have different dimensions. As you can see below, the dimension fo…
- Hi, I have a requirement to have sales bonus based on the hire date - For example, if an employee is hired after sept of 2022, the employee is eligible to get sales bonus only after Feb 23 onwards. If…
- Item(time) function not working in Polaris my time scale is month. Format is year. need to populate year Thanks
- I have 4 modules as shown in the screenshot. When I make an Override only for Brazil it is being carried into all of LATAM in Module 4. In module 4, the revenue is pulling for all the countries when i…
- Hi, I have a module name : NPI Enrolment -- this is to encode New SKUs which currently is in a separate list called New SKU(List) I also have another module called Reference Sales -- the goal is to ge…
- To use the List property in formula, one need to type out the whole list name including property name, that is a cumbersome process. Allowing Reference of List Properties, will save MB time and effort…
- In my data I have teammate roles, their names, the month that they were in that role, and the facility that they serve. In one module I have all this information listed out. I included a picture with …
- Currently in an Anaplan dashboard, if you highlight cells, you can view the summation of the values (see image below). However, when you expand the table to fullscreen, the summation does not show (se…
- I would like to get the averages for a line item using prior year month values. I can use the formula below but I don't like the idea of hardcoding. Is there another way I can do this without hardcodi…