-
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…
-
Archiving Models in Workspace
I have a PROD model that I needed to make a copy of and archive to a new archival workspace. However, I made the mistake of copying the PROD model in the same workspace that the PROD model exists in. How can I take the copied model and update the workspace without causing any issues in any of the models? If possible, I'll…
-
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…
-
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…
-
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:
-
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…
-
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…
-
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?
-
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!
-
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…
-
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…
-
Random number generator
Is there a way to generate random numbers from a defined range of numbers so that the numbers being changed regularly in a module every time we refresh the model or just run an action?
-
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…
-
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,…
-
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…
-
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…
-
exam 1 activity 6
why my region row is blank
-
add a role list
how to add a role list in the model