-
Anaplan natural rollup is not equal to sum of values from its children
Hi, fellow Anaplaners I observed some weird behaviour of Anaplan natural rollup (meaning set line item as number & sum as summary method, then parent item will take sum of all its children's values). I have 2 line items here: 1. Commercial input is number formatted; no formula, is for planners to manual input forecast…
-
Multiple Model Builders changing Actuals Through Switchover
Hi everyone - We have a large team of builders and one of the most used modules is pulling Actuals Through from the Lookup Reference module. It can be frustrating when Actuals Through Switchover dates keep changing due to people working on different things. Has anyone found a workaround or have a suggestion for best…
-
formula summary
HI All, Why we use summary as formula. what are the scenarios that we use this ? what is the outcome of it?
-
Moving values from one module to another while Line item is being used as Dimension in other
Hi everyone: Module 1: Dim - Entity (Aus 1, Aus 2....) LI - please refer below as (numbers) Module 2: Dimension: LI of first module , Parent of Entity (Aus..) Line item: Amount (which will have the values from the first module) I am getting same value distributed across all the Dim 2. Can someone help me out in this case…
-
Assign recipients via module in Notification designer UX - need to include people dynamically Role
is there anyway to include certain role people in notification alter via module dynamically??
-
Do saved views take increase model size?
Hi all, Do saved views take up space? If one module has 10 saved views vs. 1 saved view, does it make a difference on the model size? Thank you! Amy
-
Rankcumulate - unexpected result
Hi, I am using the rankcumulate function but I am getting some really unusual results, wondering if anyone could assist as I have no idea why this is occurring? I have attached the formulas and also the results. Thanks in advance
-
Combinining list members from 2 different lists
Hi everyone, Is it possible to combine list members from 2 different already available lists in Anaplan? If you know how, please let me know. I attached explanation picture: As an example, I want to create a list called "Master List" that will get data from Customer Service Manager and Sales Manager lists. List members are…
-
UX dashboard filter not defaulting to current user
In an attempt to reduce the size of a line item(used for dashboard filtering), we created a dummy list that contains a small subset of people. The subset of people has selective access enabled. I then used FINDITEM to link the Users list to the subset. The linking worked successfully. However I ran into an issue when I…
-
Picklist of months: line item formatted as month
I have a line item formatted as Time then Month. The picklist only displays the individual months and not the total FY. Is there a trick to show the total FY too? I'm trying to avoid creating a list with the months and total FY.
-
Find an item in chart with 3 conditions
Input Road 1 France Germany Type A Road 2 France Germany Type B Road 3 France Italy Type A Road 4 Italy Germany Type A Question Hello, I would like to know how to get back into a module the correct road. The road depends on three conditions as above. For example, if I am told that the road is France Germany Type B, I would…
-
Data Hub to Spoke Model Performance Question
We are building a budgeting and reporting model based on transactions incorporating our chart of accounts. We have built a Data Hub to house the lowest level transactions. Currently we budget using 6 categories with several layers of hierarchy totaling a count of 6,475 items. Summarizing monthly transactions we are looking…
-
Rank Formula || Need to Cumulate in Reverse order
Hi Everyone, I have a module dimensioned by List 1 and Time (Quarter). There is one imported line item (List formatted). I want to number these imported cells data according to the quarter. For example:- List item A has values in the following quarters Q1FY23, Q2FY23, Q4FY23, Q1FY24, Q3FY24 (other quarters are blank) so I…
-
Copying Anaplan models
Is there a provision to copy models created under one user ID to another ID? TIA, Varuna
-
Move data from fake time period to real time period (For restriction of drop down selection on time)
Hi, I want to move the data from fake week to real week. I tried with multiple formulae and still getting errors. Request your help. Please find the screen shot of requirement below: And I have a mapping module as below: And my fake week list is as below: Note: The reason why I have created a fake time is period is that my…
-
How to find MAX number on a specific Dimension
Hello Experts, Need some help on a logic wherein I need to show Maximum number for a specific Dimension out of 5 Dimensions, for e.g. in the below screenshot I need to bring 49,258 from Line Item "A" (as highlighted) which is contributed by Tennessee (which is one of the States in States Dimension, on columns) on LI "MAX…
-
Which approach is better? (Related to Text, Lists and Formulas)
Hi Everyone, I have a module which is dimensioned by one list. It has around 60k items. In this module there is one line item (Main_Text). I want to pull a string from this Main_Text line item and then use Finditem() function over that string. Right now, the approach that I am using is to calculate them in two different…
-
Help with formula using IF THEN ELSE statement with Versions
Hi, I'm trying to create a formula where the End User Input will flow to both the Forecast and Budget Version of my model. The formula I'm trying to use is below. I can get the End User Input to show in my Forecast Version, but not my Budget Version. Thank you
-
I am calculating a minimum value, but I don't want the data to include zeros.
Hi, I want to calculate the minimum value but exclude all zeros. I tried previously suggested solutions, but it is still not working. Any ideas?
-
Card Configuration - Not able to check "Completed?" Box
Hello Community, In both DEV and PROD models, I have a "Completed?" checkbox that will be able to lock a schedule. In DEV, I'm able to mark the checkbox but in PROD, the box is grayed out. I've checked the settings in the NUX page and they both have the exact same settings toggled. Would anyone have any suggestions on how…