-
Bounty Program
This is a platform to share ideas about improving Anaplan platform. But there is something I would like from your side a bounty program, for finding bugs in the platform. Just a suggestion to improve the Anaplan platform further. Thanks, Vamshidhar Reddy
-
formula
I have the problem .. i have a list on left and i have the formula like the picture .. half the list using formula and half again using formula but null value . how work for the problem?
-
Introduction to model building UX Dashboard Not Populating with Data
Hi, I'm working on the UX section of the introduction to modeling, and I cannot get the headcount module to populate with data when it's on the dashboard. Interestingly, there's data in the module itself and when I publish other modules to the dashboard they also show data. What could I be doing wrong? Thanks for your help…
-
Invalid Parent While Importing in List
Hi, I am trying to import a product list which is a numbered list form another model say ICM. But while trying to import it,it shows the invalid parent entry.However the list is getting rolledup to the correct parent. Screenshot attached.
-
List
* I want to ask about List. i want to take code on Account L0 Flat List to Account L0 . Account L0 FLat is list format .. *
-
FINDITEM formula
Hi all, I have a list named "TAT Hours" and a line item "TOTAL HOURS" that is in number format. I used FINDITEM formula to get the number of hours (TAT Hours) in the list, here is the formula: FINDITEM(TAT Hours, TEXT(IF TOTAL HOURS <= VALUE(NAME(TAT Type.Min Hours[LOOKUP: 'TAT Type1'])) THEN VALUE(NAME(TAT Type.Min…
-
Line Item Subset for Text Formatted line item
Is there a workaround for selecting a non-number line item in a Line item Subset? I've created a filter for increasing and decreasing the number of lines shown in a dashboard table using David Smith's outline in this…
-
Counting Multiple Countries Per Region
I have a module that needs to tell me whether a customer is present in more than one country in each region. For example, Customer A is only present in United States under AM region. This means that it is not an inter-region customer in AM. But in EU region, it is present in United Kingdom and Italy, so it is an…
-
Section 12, Activity 17 - Ramp Line Item
Why is ramp format a number and not percentage?Am trying to appreciate the formula and output on this line item.
-
Version formula
i'm using three versions in my module, here Actual, Forecast, Budget. i have the actual and budget data available and they can be manual entry data. Forecast data should be formula given. Actual Budget Forecast Jan Forecast Feb ---- until Forecast Dec Thank you,
-
Version Formulas
i have a question, on my project i have many versions such as Actual, Budget, and Forecast(Jan-Dec) . on Actual and Budget version will input by user but for Forecast this will retrieve data from another forecast module version? how is it done?
-
Use SUM Rules Dimensioned by Users for Source Data not Dimensioned by Users
I recently posted a question on the forums in relation to a workaround for a bug in the LOOKUP formula. I wholeheartedly feel like the LOOKUP bug (where it doesn't work for parent items that are in the same list as the leaf-level members) should be fixed. And I recognize that there are some workarounds available (as…
-
Formulas
What is different about LOOKUP and SUM?
-
Rankcumulate till previous Rank
Hi All, In simple terms I want to know the total till the previous rank complicated by the fact that the last number depends on the rankcumulate till previous rank. Hence this is giving rise to Circular references. Let me give an example (see attached) * I have sales volume of SKU by date dimension ( though this data is…
-
FORMULA
HI Experts, We have line items Line item:1 : FCST_1 Line item:2 : FCST_2 based on FCST_1 convert into Rounded value. Both line items are text format. First item data in dot(".") format but we need to convert comma(",") And we need round off the FCST_1 line item. For suppose FCST_1 = 1.2498 then by using some formula we…
-
Parent Level Inputs
Having the option for user input at a parent level in a module would be very helpful. For example, our users are required to leave commentary on their monthly variance to actuals. Currently, they are only able to do this at the bottom level of our Cost Center hierarchy, but many of them would also like to leave commentary…
-
Formula Structure for Performance
how to create best formula for using IF ELSE?
-
How to create formula that calculates the first child of a given parent?
Hi, I need to map high level data (Product) to leaf level (SKU) for exporting planning information to transactional systems. Each product has multiple SKUs so we'd like to automate that mapping by using the first SKU within the hierarchy. I can calculate the SKUs sequence within each product using RANK function but I'm not…
-
Find 5 Saturdays in a month using Date functions and not Calendar type
Hi, I am trying to create a boolean flag that will tell me if a month has 5 saturdays or not. Can someone guide me in constructing this with date functions? Unfortunately, I cannot change my calendar settings to 4-4-5 etc because of business restrictions, so I have to calculate this manually in order to adjust and smooth…
-
Intermediate Model Building - Req Quota Module - Goal calcuation is not working
I've entered this formula for the goal calculation. IF Active? THEN ROLE GOALS.Quota Goal[LOOKUP: Region, LOOKUP: Role] / 12 ELSE 0 I'm getting this error. Dimension of mapping used for lookup doesn't match any dimension of the result Has anyone else run into this?
-
SUM vs LOOKUP vs SELECT
Hi everyone, Capps Europe and Advanced AnalytiX have made a video on how to use SUM, LOOKUP, and SELECT functions in Anaplan. The way these functions work is quite different from Excel, and hence they may often be confusing for beginner Model Builders. I hope you will find this helpful. The video is available here.
-
Push Boolean selection from input module to detail module
Thanks in advance for the adivce... I am trying to push a boolean selection from one module to another. Let's call them input module and calculation module. The input model sits at a hierarchy several levels above the detail module. Input Module has not time version or time dimension and sits 3 levels above in the…
-
Pick list item based on property and use it as a dimension/LOOKUP
Hi, I have a list "Aging Buckets" with list items like below, and 2 properties (Range Min, Range Max): Range Min (Property1) || Range Max (Property 2) Bucket 0 0 1 Bucket 0_30 1 30 Bucket 30_60 31 60 Bucket 60_90 61 90 Bucket 90_180 ... .... Bucket 180_360 181 365 There is an "Average" module which is dimensioned ONLY by…
-
Create a new module with TIME (and others) as dimensions from a module where TIME is a line Item
I have a module called Sales: dimension is a list,Employee-Product Groups. Line Item is Units Sold and Time Period (MONTH). I want to create a module with 2 Dimensions , Employee-Product Groups and TIME, and the rest of the line items. Please help.
-
Retrieve time period where a certain value matches
Hi, Anaplaners, I am struggling with how I can retrieve Time Period where num1 matched to num2 (please see the attached file for the detail) Thanks in advance for your help (cell colors in the file do not intend conditional formatting)
-
Count layers in a list?
Hi, I am looking to count the number of layers (not descendants) in an employee hierarchy. For example: Manager 1 has 3 direct reports Mananger 2 reports to Manager 1 and has 4 Direct Reports Manager 3 reports to Manager 2 and has 1 Direct Report The result would be: Manager 1 has 3 levels Manager 2 has 2 levels Manager 3…
-
It would be helpful to have an “aggregation operator” property that would apply to a hierarchy.
For example, consider the following hierarchy, applied to a module, with the following values: Net Income: $10 Gross Margin: $40 Sales: $100 Cost of Sales: $60 Operating Expense: $30 Clients would prefer to see Cost of Sales as a positive number. In aggregating, they would want to see Cost of Sales subtracted from Sales to…
-
TIMESUM/Returning only forecast period values
Hi, My current module has Year as the time dimension and my reference module has months as the time dimension. I want to return a field from the referenced module but only for the forecast period (Current Period is set to Jan19) & hence for FY19 that would be the sum of Jan19 to Jun19 and FY20 Jul19 to Jun20. My formula is…
-
Create a new line item to be max of old line item
This might be a silly question, but I just got stuck and couldn't think of a solution. I want to create a new line item showing the max of an existed line items. Take the example below, I want to create a new line item called max days, which takes the max of Days. Original: Days A 1 B 2 C 3 D 4 New: Days Max Days A 1 4 B 2…
-
Use Page Selector Item in Formulas
The ability to use what is selected in a page selector in formulas and filters would be very useful. Although you can create a custom filter with a cell acting like a page selector, if multiple people are on the dashboard and using the cell, it can cause confusion.