Modeling

11.3.3 Activity: Add Profit & Loss Report Module
Hello All, When I put this formula, IF 'SYS09 Version Details'.Forecast? THEN 'OTH01 Non Employee Expenses'.Shipping Costs ELSE 'DATA01 P&L Actual and Budget'.Shipping Costs I am getting this error The formula for 'REP03 Profit & Loss Report'.Shipping Costs is invalid: Shipping Costs = IF 'SYS09 Version Details'.Forecast?…
Deleting item from general list
in model i am not able to delete the organization from the general list. please can somebody help me out from this
Level 1 Lesson 11.3.4
I have been stuck on the first formula for days. When I enter it the error I get is: I'm not sure what this means, I have gone back and double checked the naming of all of my modules and made sure I was typing the formula correctly I've tried typing it, copying it, no matter what I do it won't work. If someone could…
Time Settings by Year issue
Hi @noelle_murphy This is not displayed as year any comment
saying invalid formula
can someone tell the exact problem in the formula
New UX: Model Status/Refresh Messaging on New UX Page
Idea is to have a message or status on the New UX page in order to notify user that something is happening in the model that is causing the model to queue or be blocked (examples include: save state, actions, etc.). The lack of messaging causes massive frustration for users who think the New UX page is "slow". The classic…
Alias Property or Label
Description of the enhancement required: Alias Property or Label An example of the enhancement: The Item Name in a list might not always be indicative of what they might want to see in a report, but it’s how it’s stored within their metadata structures so it’s currently what’s being used. Sometimes as part of an alias they…
L1M1 12.4.6 activity. Create Saved Views for Employee
Hi All, How to add E2 Employees#: Active? directly to pivot. I tried to find the option but failed. I have subset E2 Employees#: Active? in E2 Employees#. How can I add this subset to pivot? Please help. Thanks, Balarama Krishna
Struck at L1M1 12.4.6 Activity: Create Saved Views for Employee Expenses
Hi All, I am struck at this. The training materilas asks Create a new saved view: * Pivot the view: * Pages: E2 Employees#: Active? * Columns: Time * Row: Line Items * Filter: Show Forecast Months only * Save and name the view: Forecast Periods My Pivot shows In my saved view everything is showing correct but I am not…
List
Is it possible to create single list with parent child relationship?
number of months left in the model calendar
Hi, I'm looking for a way to reference the last month in the model calendar. For Example My model Calendar is 1 previous year and 2 future years. Currently the last Period is June 2022 however when the model calendar increases i want the formula to reference the new end period. I then want to count the months from the…
Dynamic Native Version Selection in Export Module
HI, I have a staging Module, version dimensioned where I collect the data I need to export. In the export module, I would like to remove the Native Versions and make the versions selection dynamic. So that the Line Item – Amount collection would collect the amount from a selected version. Version Selection module (below…
NUX+New Model Experience: Open from App page directly the module
As model builder, I would like to open directly the module published on the App page in New Model Experience. (not only the model). Currently, from an App page, it is still opened ONLY the source model and it is opened in the classic way (not even the New Model Experience). When New Model Experience is activated, I noticed…
Display Name for List Subset
Hello, Can we somehow have different logic for Display Name for different List Subset? I have a module with lets say "SS:AS" subset of a list "A" as a dimension and a line item called Name. I want the display name to be changed in accordance with the Name that is entered. I don't want an import. The display name property…
Synchronize Selection conflicts with Quick Filter?
Hi experts, I faced a problem on classic dashboard, that when I try to use Quick Filter then a caution message below popped up and cannot add a Quick filter. Synchronize selection is mandatory in this model, then how can I avoid this issue? What is wrong? Regards, Inoue
Add ability to assign a functional area to a new module in the create a module dialogue box
It would save time to not have to always go back to the modules tab and assign a functional area if I could do it upon creating the module, which seems sensible!
Formula Bar not Working
Anyone else having issues with inputting formulas into the formula bar today? Currently, it is not possible to either type, click to reference, or do anything with the formula bar. Obviously, this is quite a problem if you're looking to build anything new! I'm using safari and colleagues with chrome and firefox have the…
2.4.7.1 Conditional Formatting
I do not understand why my module does not match with the 'Check your work' module. Could anyone please help me out...
Ability to add folder structure in model management
Description of the enhancement required: Create folders and keep the models in various folders How would it help their business process: We have about 15 modellers working on different models. Wed like to be able to organise them better. Sometimes we might forget the names of models they are creating. In windows, they can…
BOM Creation in Anaplan
Hello Everyone, In supply chain projects, it is often to have a BOM with more than 15 levels. One level can be both parent and child. and for one level, we need to identify all of the parents in order to calculate the quantity to produce. Clients often provide a file with at least 3 columns, The first one is the compound,…
About formula
Hi i am trying to write the formulas about Actual/ Forecast here i have actuals data and forecast data and current month selection i am trying to write here IF ITEM(MONTH) < = Current month Then Actuals else Forecast here i havve everything like I HAVE MONTH LIST AND CURRENT MONTH MODULE Actuals data and Forecast data..…
How to transform order volume to invoiced volume?
Hi There For a sales forecast of an onlineshop I have the following problem to solve: I know the daily volume forecast (in a number of dimensions) of what customers order from the shop. From that daily order volume I want to derive the daily processed volume (by the warehouse). When the warehouse complete processing…
Unique Project Names
I allow users to create a project which gets tagged to a numbered list (Projects), Users are expected to give a name, is there a way I can let the user know that the name already exists ? I have brought a logic to check that but its somehow not capturing Capital letters For example, if project is named 'Jack' and if user…
Anaplan Way Course prior to Level 2 Model Building?
Hi, Does it help or is it necessary to complete the Anaplan Way course prior to beginning Level 2 Model Building course? Thanks in advance for answering my question. Jacob
Level 3 Sprint 2 Problem of Quota of Sales Reps and Assignments (User Story 3.2)
Hi, Misbah For calculating the Target of Sales Rep, I created a Line Item Sales Rep in TAR02 Account Review and created a formula of Target applying to Sales Reps Flat# in QUO07 to obtain the Target of every Sales Rep, but I received a message, but the result is not good. The Target showed Total of all Sales Reps and…
L1M1 Lesson 6.3.2 Format settings
Hi, At the end of this lesson in Knowledge check I did arrange the Format settings as shown in the shared image below. For this selection it is showing invalid answer. Please can someone advise what is wrong here. Thanks, Balaram D
Calculate First/Last Week
I want to calculate First/Last Week Like this picture. I set the "General Week" as Time Setting. I have no idea to do it.
Stop Summary in the middle of Hierarchy List
I have this type of List. ALLRegionCountryWorldEuropeFrance German AsiaChina Japan I want to Sum Lineitem by only Region not All, Like this Table. ListLineitem(None)Lineitem(Sum)IdealWorld 40Europe 22France111German111Asia 22China111Japan111 By calculating this table, I can filter Country List by Ideal Lineitem. How can I…
No sounds in Anaplan Level 2 Model Building: Sprint 1's 1.3.2 Import Errors's Summary sections
No sounds in Anaplan Level 2 Model Building: Sprint 1's 1.3.2 Import Errors's Summary sections, as picture shown where the exact part as I am referring.
Getting issue in accessing already loaded list
I have already loaded data to the list and used in the module but when i started giving exam of sprint-2 and it has to be answered from the activity we did in the hands on. So after opening this module two days later I am getting below error. How should I debug this problem.

Modeling

Discussion List