Modeling

Help with Profile formula adding up few line items
Hi all, I keep having the same error, when I tried to add up few line items with PROFILE calculation in it. I have created a module to calculate items of the balance sheet and multiplying them but % over a period of time. When I try to add all the items to get the total, I have an formula error as per the picture attached.…
Ranking and List
Anaplanners, I have a module with a list "project" each project is ranked with a line item called "Rank" which uses rank functionality. Is there a way i can create a page selector/list which filter the projects based on rank, for example, i create a listitem called "1-5", the module should revert projects ranked in those…
New UX - Report Page Dynamic Slides
Anaplanners, Quick question, was trying to figure out the new report page available, i thought of working on a use case, I have 100 rows to be shown in the new report UX, I have published the same by publishing a table, now the whole of 100 rows comes in 1 slide with a vertical scroller. Is there a way i can say…
Length of Service and Tenure
Hi, I'm currently having trouble figuring out the Length of Service List and Tenure columns in the SYS08 Sales Reps Details module. There is a Length of service module already built, but it is blank. So I am unsure what to base the population of this column on. Also, I built a Reps tenure range module to calculate the the…
August 2021 Release and Sneak Peek at September
August 2021 Release and Sneak Peek at September Bulk Open from Table of Contents: From the Table of Contents section of New Modelling Experience (NMX) you can quickly open the objects of a particular functional area for faster access to the information that you may need. It leads to increase in productivity. Tab…
Level 1 Model Building - 8.5.3
*Edited* Found out my error was when I imported the header row and first data row has to moved down one row. May I get some assistance on what is the correct mapping? Trying to edit date format to allow proper importing of data but can't get to options if I map correctly. Followed previous community posts.
New UX: Nested list of Categories in Navigation header and App page
Would be nice to be able to add more than one level of category for Pages in navigation. This is how it could look like. In the example below I have a Category called "3. Procurements" which has quite a few pages which essencially consist of sub-groups: CAN, PET, CAP, etc. On App page it can look like this:
Level 1 Model Builder 12.4.6 Filtering Help
Hi, Level 1 Model Building 12.4.6 In the unfiltered view for EMP02 Employee Expenses I get the year FY total. But when I added the filter "Forecast Months Only" the FY year totals disappear. I would imagine that is how it should be. Since the filter is "Forecast Months Only." However, according to the course requirements…
MODELLING TIP! How To Convert Infinity, -Infinity, NaN to Zero Value
Loving this tip! It is so annoying when by default your data display Infinity or NaN! Check out this community article to see how to avoid it!
Copy Branch in new UX - plus some roadmap features
I know that this is already on some people's radar as a feature that sadly hasn't made it yet to UX - so please bump it up here in Idea Exchange - but in the meantime this is a useful workaround which may fit the bill for some of you: Copy Branch Workaround in UX In other UX Roadmap news -Innovation continues at a pace…
Model Size
Hi All, I am trying to estimate the size of an app before it's build. We do have the number of members in a list that will be used in a module but the numbers of line items that will be build are uncertain. Using Agile Implementation app for size estimation requires us to input the number of line items. However, What is…
Need formula help to offset time period
Hi all, I am having some trouble determining how to combine certain time functions. I am trying to forecast sales with an associated start date and end date. The attached shows what I'm trying to accomplish. I've tried offset but I can't use that with a time period. Is there another way to offset a time period? Thanks!
Getting ride of a Zero
Hi, I need to get ride of Zero's in a Override line item, so the model doesn't read it as an override? I understand this should have been set up with a Boolean in the first place but it's a little late for that. I now need to get ride of all user inputs which include Zeros. Thanks
Modelling Issue
Hi Team I have a module consisting of default Users dimension, two line items where user can select "Source Version" and "Target Version" from drop down list(custom versions) on dashboard. There is an action which copies data from selected source version to selected target version. After data is copied successfully the…
Updating Lists on Transaction Data Import
Colleagues, hi! I'm seeking your advice on the following case: on a weekly basis, there will be a transaction file with the unique "purpose of payment" texts for each transaction and potentially new suppliers that don't exist in Anaplan list yet. How can we achieve automatic update of supplier list upon import and having…
Priority distribution
Hi All - Was hoping I could get some ideas/help on this problem that I'm trying to solve. I am trying to automate the output of the "allocation" line item shown below. I have a set amount that I need to distribute into various list items based on the priority shown. The max amount allocated is shown in the first column.…
Level 1 Certification: Activity 4 and 5
Hi, I am been working diligently all day on a single problem and am coming up empty. The problem never occurred during the training and need some advice. Basically, when I import the "SYS08+Employee+Details" txt file into sys08 file unfortunately even though I map correcty the Role dimension, which I formatted as a list,…
Lookup considering the Month
Hello, I have a Price List named "Raw Materials Price", and I need to pull from "Component Cost Increase" module the % increase by Component, Plant and Period (Jan 2021), hoy can I consider the period in the lookup formula? Raw Material Price List: Formula: Component Cost Increase Module: Thanks, regards
Storing Forecasted date
Hi my model has 5 versions Rofc, Forecast. Budget, Simulator1, Simulator2.(list) Rofc contains data of actual month and future month (similar to native switchover). I am creating forecast between jun-sep every year using Rofc data of the current year and locking the forecast data of that year. Forecast can be created…
Replacement Chain
Dear Community, Hope you can help me with this requirement; 1- In fact, we have a list of products and we want to replace it for example: We have : A replaced by B then B replaced by C and C replaced by D what makes a chain of substitution A-B-C-D. What I want to display on each line is the first product of the chain in…
Multi Dimension Ranking
Hi, I have 2 modules, 1 has dimensions of TenantGroup, ReportPeriod and UserRole namely AgingperGroup. And the other module has TenantGroup and UserRole namely AgingGroupRanking. The latest module will take the data from the previous and lookup the CurrentPeriod parameter to get the exact data(of which data period) to be…
Mapping
Dear All, I have one use case in which I am confused to get the output. Below is the use case: I have almost 10 lists (A,B,C,D etc.) and each list have almost 4-5 list items (A1,A2,A3,etc.). Now the end user will have the access that he can select the list items from each list (single/multiple). Once user has selected few…
UX: Card Blocks/Groups
Initial Idea: (1) Would be nice to be able to group cards on a page into a single container and save it as a single template. This will allow me to save time on repetitive builds where I have to publish the same header with 10+ separate cards on all my pages (workflow status steps, filters, company photo, custom…
function
can someone elaborate when to use sum , lookup and select in easy to understand way. i have read it from anapedia but still struggling
Model Restore, History
Hi All! I had a small model, and by mistake I changed time (Current fiscal year) How can I restore it? Thank you.
Search Text in a String
Hello Community, I am looking for a function to find a character(s) within a string, similar to CONTAINS function. For example, I need to find the word Ananplan in the string "I love Anaplan". Is there a function for this? If yes it will be really helpful if you can share. Thank you, Yogesh
Increase the auto-logout time from Anaplan Workspace/Models
Hi Team, As Anaplan came up with the auto logout feature, it is good from the safety point of view. But its quite annoying most of the times. As a developer we get involved in multiple other tools and suddenly Anaplan logs out and defaults everything. It would be really helpful if you can please increase the auto logout…
Allow semi colon as a delimiter for emails as this is the default in outlook
As a user I should not have to configure Outlook to use commas as a delimiter for sending to multiple recipients as this option is not checked by default. The MAILTO function in Anaplan only accepts commas as separators for multiple email addresses. It would be useful if it also accepted semicolons.
Actuals
Hi, Please could you help me understand which setting i have incorrectly which is populating my actuals in advance in image 1? Image 2 is correct.
13 period year
How do you create a 13 period year where P13 is added into Q4?

Modeling

Discussion List