-
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
-
Sum Weeks to Months based on date of WeekMonday
Hello everyone! I am desperately trying to map which weeks go into which months, based on the date of the monday. The monday should hence decide the month for which the given weeks data should be allocated in full. Please see enclosed image (see "ISOWeekMondayMonths"), where I have managed to have the system automatically…
-
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…
-
Hide one dimension in a column when there are 2 dimensions
Hi everyone, Anyone knows if it is possible to hide the time dimension without taking it out of a certain module? In this specific case I want hide the years (FY20 and FY21) but still have time as a dimension. My final objective is to have this table on a dashboard without the year indication on the columns. Just for…
-
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
-
Hierarchy Filters
Hi, I have a requirement where in if user selects a Boolean(Show Ending Balances) then it should show only ending balances (which is a top level for L1 description types of list) along with Ending Balance line item. Currently I have built the logic but when I apply the summary as formulas it throws an error. But previously…
-
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…
-
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…
-
Formula help on finding a % of a Calculated LI
Hi, I'm trying to create a formula where it will create a % based on taking my States List parent by each individual state. The formula I have so far is Total Collections / Total Collections[SELECT: State.North America] . I feel like this is correct but my percentages are not looking right. Please advise. want to take this…
-
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…
-
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…
-
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…
-
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…
-
level 1 lesson 11.3.4
i am not able to apply the formula
-
Finding the first working day of the month
Hi guys, I am trying to create a calendar. In this calendar I need to pull out the first working day after day X. For example : I have a module with holidays, working days etc. as booleans and on the other side I have 1st of january 2nd etc. Let's imagine the 1st of jan is a saturday. I would like then to check the 2nd of…