-
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.
-
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
-
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?
-
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
-
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…
-
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
-
How to check if are all columns correctly filled in?
Hi, I'm trying to check if all the info are correctly filled in , I mean the line items used (format as list) are correct? I used ISBLANK function, but seems it's not correct when I'm changing the currency for example, the check it's still there. Can someone help me with this? Thank you!
-
8.5.2 Activity: Import Data into Price Book Module
I can't import the Pricebook.csv data into my plan successfully. I have attached screenshots of my mapping which was done exactly as the example screenshots in the 8.5.2 Activity. Any help would be appreciated. Thanks
-
Regarding workspace
Hi Team, I have registered for free trial access but still I am not able to access workspace. Could you please help me to set my access for Workspace so that i can start working on my certification Thank you.
-
Level 2 Sprint 2 Forecast cf formula
I have been struggling with my formulas and I just wanted to check that my Forecast cf formula was correct. It worked the first time which made me nervous. The instructions are: * If Initial Demand Forecast is EQUAL to the Final Forecast, set value of Forecast cf to 0. * If Initial Demand Forecast is NOT EQUAL to the Final…
-
How to check Currency based on Company Code?
Hello, Which formula should I use in order to bring the correct Currency based on the Company Code? I try with FINDITEM and LOOKUP functions, but I guess I'm doing something wrong, as I have errors. Thank you in advance for your help!
-
Current Fiscal Year setting in Time?
In the Time setting of the model, I just updated the current period to Jan FY22. The Current Fiscal Year still shows FY21, and I don't seem to have an option to change it. I'm not sure if it is doing anything? But how do I update it and shall I update it? Is there any risk? Please see attached the time setting screen shot.…
-
REP04 Employee Expense Summary Formulas
I am trying to develop calculation formulas for the REP04 Employee Expense Summary, but keep receiving errors and incorrect numbers. I posted each of my attempts with screenshots of formulas and results below and would like guidance in developing the appropriate calculation formula. First Attempt (1A): Created a basic…
-
Bulk Copy Action
Hello all We are refining the functionality for Bulk Copy as an action. We could do with some clarity over how you see this being used, specifically with regard to ALM. Just a couple of initial points 1. We are not changing the existing functionality of the Bulk Copy action on the versions screen 2. We are going to allow…
-
level 3 - 4.6.5 Sale Planning Model: DAT02 module
4.6.5 Sale Planning Model: DAT02 module In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters * For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data…
-
Level 2 trainer led course
Hi....does anyone know why there are no trainers led course for level 2? I know the course is available in the academy, but I have done the level 1 in a trainer led environment and I found it easier to learn that way. Many thanks
-
Order list function issue
hi Having issues with end users being able to run the order list function. I as workspace admin can use it fine, and if I set my access level to their level, it works. but the end user cannot all actions, modules and list access is granted to the end user as it should be. but they get the below error. I tried removing one…
-
Level1: EMP03 Employee Drivers by Role does not return any data
Hi Experts, Below formula does not return any data, i tried many different types but it does not work. but the EMP01 employee driver returns the data. 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role, LOOKUP: 'SYS08 Employee Details'.Department] Regards, Kiran.
-
Can't refer to Lists in a new formula editor NMX?
Looks like with the last change in NMX in a Formula Editor is not any more possible to refer to Lists. So the only way is to type them in. It's very time consuming and error prone. Could you please have a look if it can be changed.