-
FINDITEM of first 3 character in List
Hi, I have a module with say a Product dimension consisting of 3 Letter product codes, e.g. APP, ORG, PEA. I would like to find these items in a list where the Names in the List are 5 Letters e.g. APPUS, ORGUS, PEAUS. How am I able to lookup APP against the list of APPUS (first 3 letter) and return ÀPPUS?
-
New User
Hi All, I am logistics professional and i want to learn the Anaplan and need your guidance to start the journey. pl help. Regds, Chetan pophale
-
Find a list member based on boolean check
I have a scenario module dimensioned by scenario. And a line item formatted as boolean. Based on the selected boolean check, the corresponding scenario should appear in a 'scenario' formatted line item in a module with no dimensions
-
One place to Manage all Saved Views
As We moved to New UX, There is immense work related to managing saved views from modules. urrently set up does not allow to edit Saved views with ease. Having a single place to manage/edit saved view like we have a button for Modules/Dashboards will make a significant difference to Developer life. Thanks Ramu
-
Getting Error "format of mapping used for lookup doenst match any dimension of the source" no clue
I have a source module dimensioned by tmpSalesTerritory list, that is a numbered list Need to get “final_segment_country” and put it in this module below on yellow marked The problem is when I lookup the value from property module I received the msg below… Can you help me to understand what is happening? Since I getting…
-
FIND Function
Hi Team, I'm using the FIND function for the 1st time & it not working as I expected. It seems like a basic Function so I must be missing something easy but I would assume that below the value returned in the FIND line item would be 1 as it would find ANZ? Thanks
-
Calculate MOVINGSUM from module with no time to module with time
Hi there, I need to reference a source module line item with time to a target module line item without time to achieve an Actuals Rolling [6, 12, 28, 24 months] SUM using MOVINGSUM. In this case, it would be the sum of the previous 6 months from Jan 22. Please see attached screenshots and let me know if I can provide any…
-
Number Import
Dear Community, I am importing 1.000- into a numbered format line item, system is recognizing it as 1000. Any reasons, why it is happening and how can we overcome it? Thanks & Regards Badam
-
2.3.8 Activity: Volume Growth Rates
I input formula Growth%= MONTHVALUE('DEM01 Volume Growth Rates'.Growth %). Timescale has been set to week. Summary is None. View on DEMO 2 shows zero. attached screenshots. Am I in the correct direction? Thanks.
-
Scenario Question for Time Settings.
IF MODULE A = CUSTOM CALENDAR & FY19 DATA, MODULE B = MODEL CALENDAR of FY21, then how can we get MODULE A DATA to Module B as FY21?
-
Data from With time to No time Dimension
How can i pull a data from a module with time dimension to target module with no time dimension using a finditem mapping made in the source data? To illustrate, my total sales of 1,000,000 was divided into 3 months(using a time dimension) using a condition that turns the distribution this way: Jan 20 - 3,000,0000 Feb 20 -…
-
LVL 2 DEM03 Override? formula
Hi Team, Inserting formula for a boolean line item as: IF Override? THEN Final Forecast = Override Forecast ELSE Final Forecast = Initial Demand Forecast Error is throwing as "Circular references:Override?" What am i doing wrong? please help.
-
LVL2 inv01. Forecast demand
Hello everyone. there is a small question - the forecast demand field in my model is different from the screenshots in the tutorial. Was it me wrong in the formula? baseline forecast formula: IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0) ELSE 'DAT03 Historic Volumes'.'Offset…
-
DEM03 Week 3 FY20
I'm trying to find the reason why my number for Final Forecast (for All Accounts) in Week 3 FY20 does not match Initial Demand Forecast number. I attached the screenshot from the page.
-
Change 100items at the same time,from "Clear target prior to import" to "Only update imported cells"
Hello Anaplan! It will be very helpful to bulk updates in the Actions settings. In particular, the setting "Clear target prior to import" to "Only update imported cells" in 100 items at the same time, rather than doing so 1 by 1. Anaplan, Could you create something to do so? Thank you in advance!
-
Change 100items at the same time,from "Clear target prior to import" to "Only update imported cells"
Hi there! I would like to know how can I change one settings characteristic in my Actions. In particular, would be to change from "Clear target prior to import" to "Only update imported cells" in 100 items at the same time, rather than doing so 1 by 1. It would be very usefull. Thank you in advance Community!
-
Profile for prior periods
The profile function is great when you want to calculate data from a start month for future periods, it would be great if it would also work to profile data going back in time from the start month
-
Reverse Profile function
It would be good for the PROFILE function to have the option to work going backwards as well as forward in time,
-
search next boolean item
Hi, I want to do like this table "temp2" Lineitem searches the days from now to next temp1. Time2022/1/12022/1/22022/1/32022/1/42022/1/5 temp1 ☑ ☑☑temp213211・・・ Is there any function like this?
-
Image Cards
I have a Text URL line item in a module. I want it to display on my page when a condition is met, e.g., if Employee Name is not blank. I have a filter in the view, so it will not display a value for the line item when there is no employee. However, the image card on the NUX page always displays the image regardless if…
-
12.4.1
Good evening! Please see my screen shot below. The training asks us to do the following: Create a new saved view: * Filter: Forecast Months only * Saved and name the view: Forecast Periods My apologies in advance but I'm not sure how to acccomplish this section. Please advise! Thank you!
-
Model Building L1 Exam Activity 4 -Data Mapping issue
Hi All, Can someone please put me in right direction, I am unable to map data from Employee+details+by+Role.csv. I have selected options in the screenshot but it does not update all records and ignore departments and Region items. Please see the screenshots. Thanks so much. TB
-
Accessibility: 5 tips for building and navigating Anaplan using voice input
Whether you’re disabled in the arms or hands, interested in preventing repetitive strain injury (RSI), or simply want to get more work done while pacing around the office, today I'm sharing my tips for any Anaplan Model Builder who wants to use the tool with their voice. For my computer activities, I primarily use the…
-
How to get First Non blank value from a line item which has no summary settings
Hi Everyone., I have a module that is dimensioned by Product List. Two line items are added, one is Product List formatted, while the other is text formatted(this is not dimensioned by Product). Product line item will have only one product at a time. I want that non blank value in "First non blank" line item. How to…
-
New UX: Warning before leaving a page that has unpublished edits
In classic, when I make changes to a dashboard and try to close the page, I am given a choice whether to discard or save the changes. Perfect. In New UX, i have lost major edits without realizing it by clicking an action, my page gets changed to where the action points. Then my edits are left unpublished and therefore…
-
how to download multiple pdf document link in anaplan
Hi , I have module with number list dimension and a hyperlink line item . User can click on each link and download the PDF . But is there any way that user can download all pdf at once . Thanks in advance .
-
Conditional Format of Colum Results
HI Community -- I have a column (text) that returns either a value off 1 or 0 . but I want to create a column that actually creates the corresponding value . For instance is the value is 1 then its Direct otherwise is Fund. Fund or DirectNew Column 1Fund0Direct1Fund0Direct0Direct1Fund1Fund1Fund1Fund1Fund1Fund1Fund
-
level 2 model building sprint 3
Hi, I am at level 2 model building where I would need to create a UX page. one of the requirement is to "create stock exception count by product SKU and total for parent product at monthly, half year and year time period". The time scale in the INV01 Inventory ordering module is weekly. I presume the UX page grid will be…
-
Hello, Introduce Yourself
As a Model Contributor myself, I would love to meet everyone else who's on the same journey so please tell me more about yourself. Here's who I am: * Name: Beauram * Current Company: Anaplan * How long I've been using Anaplan: 4+ years * Completed Anaplan Trainings: Level 1 and The Anaplan Way. I've been on the last sprint…
-
Level 3 4.6.5 Sale Planning Model: DAT02 module
Please advise in my DATA02 looks ok: below I am worried that I have sparsity here compared to screenshot of check build; my totals are the same though thank you