-
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…
-
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
-
exam 1 activity 6
why my region row is blank
-
exam level 1
stuck in Activity 2 i am stuck here please help
-
Parent hierarchy & Top level
Hello fellow Anaplanners, I have a query, I was going through an existing model and where I saw there are multiple composite hierarchy built having just 2 lists. i.e one is parent list (say 'X') and another is child list (say 'Y'). Now here in first list 'X' (which is parent for the other) there is only 1 member 'All X…
-
Ability to import a table from a report page to a board or worksheet
Hi everyone, I was wondering if it is possible or if anyone knows how to move a table from a report page to board or a worksheet. In this specific case I had to use a report page in order to use the "variance in report pages" functionality which does not exist neither in board or worksheet pages. This is what I have…
-
Statistical forecasting App in UX
Hi all, I can see that there's a statistical forecasting App on the App Hub that can be downloaded but it looks like everything is in Classic dashboards. Does anyone know if there's a version of the app that uses the UX? Thanks
-
Add columns to modules with differences and ratios and between years
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that shows how much it grew from one year to the other. In this specific example I want to create something as can be seen bellow…
-
Lookup Sales Based on drop down list
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store. Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store…
-
Add columns to modules with differences and ratios and between years
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that shows how much it grew from one year to the other. In this specific example I want to create something as can be seen bellow…
-
Reset boolean when selecting a new hierarchy in UX
Hi all, Hope someone can help me I have a 2 grids connected and set with restrictive access, What happens: First: When I select the country (1st card) to be updated on the graph (2nd card). The selection is kept when I change region. Example: US-Chicago Second: But if I change region to Europe, the Chicago previous…
-
View access based on User list
Hi, I have a module where users create New Cost lines. Since the security is based on Groups, users can see costs created by other users within the group. Now the ask is that users should see the costs created only by them, for example, User A would see cost items created only by A, B should see only B's lines etc. Note…
-
Pulling value from another line item in the same module
Hi I have an Emp List. An employee can have 2 records in the list (the 2nd one with an extension ABC OR). I need to pull the values of the 2nd record in another line item of the 1st record. Could you please suggest how to show the values in Red below? Thanks Is ABC OR?Projected salesABC OR SalesJohn DoeY1000520John Doe ABC…
-
6.8.6 Activity: Add Formulas to Location Details Module
Hi Team, I got the error message in 6.8.6 Avtivity, I couldn't create formula here, anyone help me? Thanks
-
level1 lesson 11.3.4
i am unable to set the Formula
-
level 1 lesson 11.3.4
i am not able to apply the formula
-
Summary Settings in module Blueprint view
I'd like to know the difference of Summary settings combination in the blueprint view between: Summary- Formula, Time Summary: Same as main summary vs Summary-None, Time Summary: Formula If possible can anyone explain me with a small sample data like this:
-
Tell us your thoughts on ALM via a short survey!
Customers and Partners, Please take this short survey, which should take you less than 10 minutes to complete, to tell us your thoughts about ALM. Thank you, User Experience Research Team
-
level1 10.2.1
what would be the formula of total here?
-
Pricebook to flow down from Parent to Child
Hi, The above are currently in the system where L4 is a list of distributors. I do not want to touch/amend since i am new to Anaplan and do not want to mess up anything. I created a new list as below; I have created a system module to link L3 distributor to L4 Customer in the earlier list. After which, I have also created…
-
Applying different formulas to list
Hi, i'd like to ask about how to apply different formulas on each item in a list. As You can see, Module 1 shows actual data from the current month. Module 2 is a forecast module, where the baseline column is from the previous month actual data, while the Growth % and Growth column is an input column for expected growth…
-
How to create a module where i can link existing module to a new list
Hi! Not sure if the subject header make sense but here it goes. I have a existing module that have pricing by distributor by month by SKU, example and lists used as below; Different distributor will have different prices by SKU The above are currently in the system which i do not want to touch/amend since i am new to…
-
lesson 10.2.5
how to change time to closing balance?