Modeling

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
7.2.1 product data import
Hey Community, I tried different ways to import data, but still i am not able to match code , can you please help me out. I am attaching screenshot below.
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.…
DEM 01 Volume Growth rates
Hi there! I've uploaded the file as per the exercise, changed the date to the MMM-YY format. It says 96 items updated. However, the module is showing the value only for January. Please help me with this! Tulsi
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…
REQUEST: allow the model builder to change the name of an Import action before hitting Import.
Save them from needing to find that import in the Actions list and change the name there.
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 1 Model Building Exam Activity 4 - Roles Import Error
Hi there, I've been stuck on the import into the SYS08 Employee Details Module (Activity 4). When I run the import, I get the error below: I think this is what's preventing me from sourcing the right answer for Question 5, since the mapping on activity 5 works well for me. Here's how I set up the Roles list: and I've added…
Input module
Hello everyone, I've created an input module where user can fill automatically some data. I need to create a rule to load the new data entered by the user in a collection module. The collection module should has the same dimension as the input one, but I'm not sure which formula I need to use. I don't want to use a Boolean…
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…

Modeling

Discussion List