
Calculation Functions
Calculation Functions
Discussion List
- Hi all, I've had some trouble lately with combining the LOOKUP/SELECT function and the summary function, when working with percentages. Let me show the issue with a concrete example. 1) First of all I…
- Hi, We have a new request from our sales ops to consolidate some plans. The ask is to consolodate two different sales titles, each from a different territory, each with a different quota component. Th…
- Hello All I have a Masterfile module that has lines items that use a select function to get the data for a specific month. However, I am now trying to make the module dynamic. This means that the end …
- Hi, I'm trying to understand whether I can return a Dimension/List item when referencing a Line item rather than the Line Item result itself I have 2 modules. 1st module is dimensionalised by FX Rates…
- Hi-Experts, I Have a requirement for that I need your help. Module name: Summery module Dimension in the module - Time, Category, Product, customer I wanna move to all products(except fruits) sales da…
- I have three lists: Product Lines L1, Product Category L2, Products L3. Total Products is the top level of Product Lines L1. I'm trying to calculate the product mix of each product in Products L3 as a…
- I want to be able to select the parent from the same list and also another list, is there a way to do this? I am creating a Chart of Account, so there are certain account in the same list that I want …
- Hi All, I have a source file with Parent/Child and node Levels, total 7 levels max. I want it to Load it to Anaplan list(7 different list) at different list levels. we are creating 7 different load fi…
- I am creating a Income Statement where I would like to see a column for eliminating intercompany activity. Has anyone built a report or module that handles eliminating accounts?
- I want Anaplan to check if the FORMAT of my line item correspond the the formula i'm entering BEFORE starting the calculation and if the format doesn't match the expected result, i want Anaplan to hol…
- Hi, I have a List with accounts starting from 4* ,5* and 6*. These accounts have some data value against them,I want to Sum up the data value by 4* ,5* and 6*. Regards Madhu
- Hi Can we use time rang for finding time period while using finditem function. Thanks & Regards Keerthi
- Hi, I've set up a numbered list with an name property. The formula comes from a module - it should update the numbered list as well - any idea what I'm missing. Thanks.
- Hi, I want to import data into module which has Account list, where Account list has code-description format Example '1000004 - ABC' My Source file has account code only with balance. i,e Account Bala…
- Hello Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against…
- I am trying to lookup (using the lookup formula) the fiscal year, fiscal quarter, fiscal period and fiscal week using the date an item was sold. We have a calendar module that contains all of the conv…
- Description: Being an Anaplan Builder, I would like to be able to have a date format with Time in it (hh-mm-hh) Some of our planning tasks are connected with work with exact timing (Date + Time). Curr…
- Hello, I'm trying to use month to date formula. It doesn't look like it's working correctly. cumulative amount should never decrease if i'm adding values month on month. Thanks
- I want to be able to enter a starting amount and from there on have a formula driven on the line item. Example. Beginning ARR manual enter amount in Apr, then it will drive the calculation to get the …
- Hello, I'm trying to pull weekly data into a module that is based on months. I've tried to use the WEEKVALUE formula, it returns 0. My source data has a week value assigned to it. Thanks Hina
- I am calculating an average but I do not want the zero values to be included in the average. How can I exclude them?
- I'm trying to create a formula to say IF 'countries-filter'.'1' LOOKUP[Countries.'UK & ROI' ] THEN 'Actual (Current View)' - 'Forecast (Current View)' ELSE 'Actual (Current View)' - 'Forecast (Previou…
- I have two module. One call assumption, another. call Implied new room. I want to get the data from the line item call mix which is base on my subscription list from the assumption module . In my Impl…
- I had the original Model, and I was trying to replicate it. The pic 01 and 02 are the Original ones. The pic 03, 04, 05, 06 are my Model. It is restricting me to enter the values:- Soft Drinks, Tea...…
- This is in regards to the SUM on the bottom right corner when you highlight the total number. It varies from different Hierarchy level of my chart of account. I have a parent and child chart of accoun…
- I created a a vendor call MISC. Its to group all the vendor under a certain amount to MISC rather than showing a bunch of vendor. When I select Total Department, MISC won't show up. But if I go to the…
- I have inserted line items into a module where I have a line item subset set up. In the module where I am using the line item subset, the inserted line items do not fall in the hierarchy in the subset…
- Hi, I was wondering if there is in Anaplan the equivalent of the "COUNTIF" Excel formula: basically counting the cells in that range that match a specific condition. I was thinking of using it for cal…
- We are building dashboard with workflow, where user approve/reject demand plan, would like to keep system date so that we will know when user made changes. It would be great system default date and ti…
- Hi All having completed the 102 course I am in the process of building my first model, so please be gentle if I have asked a ridiculious question but I really cant figure this out. I have a line item …