Modeling

Ability to automatic change a specific value in a table based on changing a value on other table
Hi everyone, While building a model I came across a question. I would like to know if it is possible to update a value of a table after filling another table. In this specific case I wanted that when I changed the "desired average" of the second table the Total Sum FY19 of the first table updated with the new value of the…
Revision Tags
I have a question on revision tag and just need some extra clarity. If I make changes in DEV and want to push those changes to DEBUG or PROD model, would the revision tag be created in the DEV model or the other models where I'm pushing those changes to? I've read documentation and videos, but just want to make sure I…
Sum values without activating the Sum in blueprint
Hi, Is there a way i can get the total value in a list without activating the SUM in the line item blueprint? I want to save the space so i want to use None in Summary but i need to get the total in another module where i don't have the list. Thanks, Tom
Level 3: Sales Planning model to the Japanese Sales Representative details
Hello Can anyone help me on this one, The example on the check build 6.4 are not **** on my end my result:
Limitations of the number of lists in rows while crating module
Hi Guru's, I would like to add more than 3 lists in row section while creating the module but it is not allowing me to do so, I know page section but still i would like to add around 20 attr
Help getting the Average of a LI in accordance to List
Hi, I'm trying to get the Average of the LI "Principle Balance" by two list Items names "Turn" and "Vintage". I'm not sure if I would use the AVERAGE function in Anaplan or a TIMESUM function. This LI is in a module that is not dimensioned by time. Below is the Blue Print and pic of the module. List Items List Item Blue…
Auto generation of Code
Hi everyone, We have list of Activities that are being uploaded in a numbered list with Activity Description and Expense Group as Unique Properties. Requirement is to generate Code in Anaplan based on Activity. I've tried different approaches but not able to fulfill all criteria Example: - Activity DescExpense GroupAnaplan…
Waterfall Chart - Positive values start from previous line item
Hi, Anaplan Community, I have a question about the Waterfall Chart in the UX. I'd like to have the positive values start from 0 instead of the previous line item. I would appreciate your input/assistance. Backend:
How to remove text before the dash (-) sign
Hi, I have a line item where I need to remove all those before the dash (-). Is there a way to do this? currentexpectedXXX - 123123XX - 12341234 Thanks!
Update Entity Name
I have 2 entities where I'm trying to update the entity name in Anaplan. I was able to edit the name of the entities but I believe it's the detailed level that I am trying to edit. Please see my screenshot for the highlight levels I was able to edit and the ones I need assistance with. Does anyone have any suggestions on…
problem in using lookup statement
in sprint 3, i have been tasked to create a country summary output module with G2 Country and P1 product family as dimensions and stock safety flag count as line item. The line item will take data from inventory module which has stock safety exception count as line item and put the data in country summary module. Now the…
Formula for Role of user
Hi, I am trying to create a module with the ff details : Dimension : List : Users Line item : Roles ( format is list - roles) Is there a way to create a formula for the Line item so it will pick up the role in the User setting? Thanks!
Lookup funtion return blank values
Hi, I have the 2 modules below and did a lookup function but it returns blank values. Am i missing something?
Need help avoiding Circular Reference Error while using POST formula
I am working with a system that calculates what payments should be, then when the actual payment is made we record what that value and save it back into the model. Sometimes there are retroactive changes, which cause a variance between the calculated and the actual amount. We want to be able to post the variance to a…
9.2.6 Activity: Unable to input data in a module
Hi Team, I'm trying to make the cells input ready as these are being referenced in a lookup. But they are greyed out and I'm unable to change it. Please help.
OEG Best Practice: Inside the Hyperblock
What are blocks? How blocks are calculated – General Lists How blocks are calculated – Native Time/Native Versions Hyperblock performance Summary block counts Should I worry about blocks? A reason why we shouldn’t focus on just the block count Focus Points We recommend this article to Experienced Model Builders and…
How to know current User ID
Hi, I am trying to create a DCA where in the requestor should be the only one to be able to Submit a request. In this example for this module, I am logged in as user id Camille@abc.com. since the requestor is Mark@abc.com, the Submit checkbox should be disabled since me(Camille) is not the requestor. Is there a way to do…
breakback when using average in the summary
Hi everyone, When building a model, I came across the need to do breakback with an average as summary method, but I found that this option is unavailable. Basically, what I wanted was to be able to adjust the values month by month and see the influence that it has on the average of the full year and also be able to adjust…
Identifying REAL First/Last Month Monday Dates
Hello everyone, Please see the picture enclosed. I am trying to get Anaplan to identify the first and last Monday-dates of a given month, but I keep getting the wrong results due to the native calendar setup. Can anyone help me with a workaround? Maybe through convertering it into text and then into values and then setting…
Filter to show only list items with a monthly value?
Hi! I have a P&L based on a list of accounts (rows) and months and FY (columns) where I want to show only accounts which have a value <> 0 in any of the months in current time period. Today this is solved by a filter in the P&L to show only accounts with a value <> 0 for FY21 OR FY22 OR FY23 (model holds those three…
Error : Time Filter to two dimension (Time*Lineitem)
Hi, I want to filter this table by Time in UX. The point is this table has two dimension(Time and Lineitems) in columns. Table A I prepare Time Filter Lineitem dimensioned by time(Quarter and Users) After I filtered Columns(Time,Lineitems) in UX, but I can't see any Time and Lineitems. Table A (Filtered) If I filtered to…
Add or Adjust Time Dimension On An App Page
I have a schedule that is populating Q3 numbers, even though we are only in Q2. After doing more research, I believe it relates to there not being a time dimension on this page. Can anyone provide guidance on how I would be able to add or adjust the time dimension so that only prior and current quarters are populating? For…
Community perspective: Add a timestamp to processes utilizing Anaplan API and Python
Anaplan is a critical tool for different business processes, and it is used to handle a variety of data. One key attribute for data quality is the timeliness and reliability of the data. It is a known best practice to use Data Hub for centralized data management and then import data to different spoke models. Even though…
IF Then Else Issue
I want the Repair and replacement = Flat terminal then 1 else o (or) True else false No getting the result
Calculate classic month summaries in week model
Hello, I have a model set with a week 4-4-5 model calendar. In this model I created a module where I input the team presence per day. My issue is that I would like to calcule number of days worked per month, I mean from the 1st to the 30th and not by week as it sums up days from prior months (see image). On the image,…
Making the same Line Item both Editable and Formula Driven
Hi, I was wondering if there is a way to make the same LI editable and formula-driven at the same time. Assume that I have a module with a dimension D and line item L. Now the Line Item L is a list formatted dropdown of list P. P is a property of dimension D, which is defined for certain items of list D but not all (say…
level 1 lesson 14.4.2
why my line chart is showing a straight line only? it should be like this.
level1 lesson 14.6.1
how to change the product list to pages. it is showing in Row
IF then Else issue
I am Having two list formated line item, NOw i want chek true or 1 base on the one list item to other list item how can i acheive that
add a role list
how to add a role list in the model

Modeling

Discussion List