-
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…
-
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…
-
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…
-
Restrict the hierarchy levels in page selector
Hi - I have a hierarchy with, say, 3 levels - level 3 being the child. I have a module with level 3 as one of my dimension. For some valid reasons, I want to restrict in the page selector of this module not to be able to navigate to the upper level in the hierarchy of level 3 list- can that be done? Thanks, Regards - Guru
-
formula summary
HI All, Why we use summary as formula. what are the scenarios that we use this ? what is the outcome of it?
-
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.
-
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??
-
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
-
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…
-
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
-
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…
-
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…
-
How to get the average of a previous month in the current month ?
Hi I have a grid where in I need to calculate the average of the commissions selected for a couple of months and then to send it to another grid of a different month. How do I do it ? PFA screenshots Need help urgently Thank you
-
Rank Formula - Excluding Blanks
When looking at the page for the rank formula, there is a callout that says "Remember that if a source value is blank, the blank is ranked first for ascending order and last for descending order.". I am wondering how blanks could be excluded from a rank formula where I need to sequentially rank records based on when they…
-
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…
-
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?
-
Copying Anaplan models
Is there a provision to copy models created under one user ID to another ID? TIA, Varuna
-
Break text into new line
Hi Friends, What is the command required to break text into multiple lines in a Dashboard.
-
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…
-
Adding a common line item associated with a single list item
Hello all, Can you please advice how to add "line item associated with a single list items"? In the attached screen shot, •MU approved/agreed and •GS approved are list items and I have created a nested dimension in module, such that the line item is common for these list items. Now I need to add, the columns highlighted in…
-
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
-
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…
-
Put a condition in a lookup
Input: ABCDEFranceGermanySpainPortugalSweden Calculate : BCDEOrigin countryFrance (A)Germany (B)Spain (C)Portugal (D)Actual CountryGermany (B)Spain (C)Portugal (D)Sweden Hello, I would like to know if you can help me with the formula for "Origin Country". It is supposed to send me the information from the previous step to…
-
Boolean Selection
Hi, Is there a way where I can manipulate the boolean checked by the user and automatically selects as well the other selection? For this example, if a user selects Forecast-Aug, it will deselect the highlighted items for Plan, Actual CY and Actual PY as well. We don't want users to do multiple selection just to cover the…
-
issue in populating data
Hi Members , I am still facing an issue where in I have to populate FY WEEK 20 forecast with the Actual volumes of FY WEEK 19 ( ALL weeks ) I have used the below mentioned formulae IF 'SYS01 Time Settings By Week'.Current Period? THEN 'DAT03 Historic Volumes'.Volumes ELSE 0 Also used IF 'SYS01 Time Settings By…
-
Further help, with what should be a simple lookup
Hi, I have a ranking module as below This shows the top customers and some data changes ranked, also there is an image for each customer Now I have a module where I need to store the top 5 customers images to feed a business report A simple lookup in Excel, looking up 1 ,2,3,4,5 etc but for the life of me i can't figure…
-
Fetching Start Month and End Month for a given Quarter
Hi all, I'm trying to fetch Start Month of a Quarter input by the User. I created a line item for input by the user formatted as Time Period Quarter and another Line item formatted as Month. I tried multiple ways and looking for help to fetch Start Month (say for selection of Q1 FY20 - looking to fetch JAN 20 similarly for…
-
Rank using Unique Item
Hi, I have a module which shows change in volumes by Customer - Product (over 5000 lines) I then rank these changes largest to smallest, and have a view of that. Customer ProductLast MonthCurrent MonthChangeRankCustomer A - Product 1340,480311,576-28,9051Customer A - Product 270,32646,326-24,0002Customer D - Product…
-
Weekly subtotals for model with calendar type M/Q/Y
Hi, colleagues! Do you know any elegant solution for entering weekly subtotals or week ID's into module of model with calendar type month/quarter/year? Cause I faced such issue: FP&A team wants a module for calculating daily sales plan - that's ok, but another step of the process is review of that plan by BU owners who…
-
Incorrect Sum Total
Hello, I'm running into what appears to be a rounding error, however I'm not using any rounding formulas. We have a total of 625 employees being allocated across different locations. In the Total Allocation column from this module, my sum is 625: When running these allocations through a sum by location ('STG: Employee…