-
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
-
exam level 1
stuck in Activity 2 i am stuck here please help
-
level1 lesson 14.6.1
how to change the product list to pages. it is showing in Row
-
level 1 lesson 14.4.2
why my line chart is showing a straight line only? it should be like this.
-
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
-
IF Then Else Issue
I want the Repair and replacement = Flat terminal then 1 else o (or) True else false No getting the result