-
Version of PREVIOUS that works ad infinitum?
For actuals months I am calculating a 3 month moving average of percentages across several dimensions. For forecast months I want to repeat the results from the final month of actuals all the way to the end of my time range. Is there a formula for this? It seems that PREVIOUS should do this but it is only returning the…
-
Adding Multiple Leave dates into single line item
I am importing multiple instances of Leave in module. i used select function to get them into module. Now to allow them take maximum 40 days cumulative in a year, i want to store them in single line item. so that i could apply check there.Please suggest.
-
Conditional Import
I have two columns, Column A and Column B. Column A is a manual input and column B is populated by an import action of the data of Column A. I have created a sperate module with Boolean checks to make the data of Column B not editable using write access driver. However when I run the action to populate column B new list…
-
Cannot edit chart after publishing page
Hi, I have created a page in My Pages. I have a grid and a chart in it. However, once I have configured the chart for the first time, I cannot find the edit it anymore. The "pencil" symbol simply isn't there. Please help! As you can see, even in designer mode, the edit option is not there for the chart.
-
Delete multiple users with single click
Description: As a WSA, If i need to delete some 200 users from 1000 users list. I can upload the file with users list list for deletion and delete only those users available in the uploaded file. Solution: Each users have unique id assigned internally, we refer the unique id and delete the particular users by mapping…
-
Report/Board: Table Row and Column Height
There are four options for row height in a table output in the Report Designer/Board Designer. Even with the "default/standard" option, there is significant white space between rows. It would be helpful to have a "narrow" height option for table rows, or similar to my request around fonts, and adjustable row height based…
-
Fake Time (1-31) or Time Dimension
Anaplanners, We're in the process of creating a use case for capacity planning. Users have mentioned the projects they have working on. We will be converting the allocation into hours. Say I'm occupied for project A and Project B 75% & 25 % respectively, I will have 6 hours for Project A and 2 hours for Project B assuming…
-
Pivoting cards on Excel365
Hi, We are not allowed to import data from a saved custom view and we are never allowed to pivot a template from saved view. So when are we allowed to pivot a card? Thanks.
-
Not able to launch action in UAT environnement
-
Talent Builder Workspace Share?
I need to re-take level 1 and level 2 model building for upcoming interviews. Since the Talent Builder applications are temporarily on hold till 3/31/24 I was wondering is there anyone who already has access to a workspace via Talent Builder that would be willing to share access with me? Is that even possible? Thought I'd…
-
Gantt Chart Ability to Edit Columns
Hello, I would like to edit what is returned in the columns above a gantt chart. Screenshot below is what I currently see. I would like to remove/hide the year 2022 all together, and instead of showing months in the columns, show the numbers 1 through 12. And if that isn't possible, would like to remove the columns all…
-
Workflow: No assignees
Hi, Currently building a workflow functionality. I have a Group Task that relates to creating a budget transfer request. This task is dependant on the user input, if a request amount is higher than current budget, we would notify the budget holder. My question is: Is it possible to skip the task in the workflow if there…
-
Exporting CSV from Anaplan, incorrect date displays in Excel
When exporting information into Excel by month it brings the dates through as text, ex “Jan 18” = January 2018 and in Excel appears as “Jan 18” . Conversely when we export CSV files the “Jan 18” is converted to a date format with the wrong year “Jan 18” in Anaplan but = 1/18/19 in the CSV file. Is there a solution for…
-
PREVIOUSITEM() formula which is like PREVIOUS() but references a list item instead of time
Hi Anaplan, I was searching for the use of the PREVIOUS function but on a list item but it is not currently possible. @peter_mcanena has suggested this but only in a discussion thread. So as his idea suggests: PREVIOUSITEM(x, y) where * x: Any expression * y: List The expression x must be based on the list y.…
-
How to change code of a list?
Requirement has come to change the codes of existing lists in the Production model without losing data. Please suggest.
-
Import Action Bug
Note: The action was working fine since a year and suddenly mapping is gone due to has numbers as source . I have a module where I have a saved view to import data in another model . The line item name is same as list name which is a numbered list. During mapping Line item which is code is mapped in target list. But…
-
Level 1 Model Building Exam activity 7
Hello There, I am on Activity 7, I am able to bring the REP04 list data as described in the question. However, I am struggling with Page Selector, how can I get those dimension drop downs in text box? Secondly, I am also struggling with Line Chart, how to get years on X axis and the different colors for the executive,…
-
10.2.4 Activity: Import Data into Employee Drivers Module
I have mapped this but all the list items are getting ignored what should i do ? The correct output must be like this !
-
Level1 exam formulas error (activity5)
I tried to update the formulas but it shows Invalid fomula . Updated formulas for Bonus was below, IF Employed? THEN Salary * 'EMP 03 Employee Drivers by Role.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0 What exactly am I doing wrong here? Any help would be greatly…
-
Do you feel it will be good to have Supply Chain related functions ?
Since Supply chain use cases are picking up, do you feel it will be good to have supply chain specific functions in Anaplan. If yes, then kindly promote the new idea I posted.
-
errorwithclearrequeststatuspoll exception?
Getting this while inputting in a value in a column.
-
User report and additional user fields
Ability to generate user listing report which show the following: User ID User name User model roles User workspace access User SSO Additional user field to input company employee ID User creation date User last login date User deactivation date The above are minimal user information required to meet general Enterprise…
-
Error on Excel Add In
Hi, does anyone know what this error is? Thank you, Joana
-
Conditional Formatting based on a Hierarchy List with more than 2 levels
Hi everyone, I have an issue related to the creation of a conditional formatting formula line item based on a Hierarchy List with more than 2 levels (in this case 5 levels). How is it possibile to calculate the column C conditional formatting based on different hierarchy levels in a single line item? I have tried in many…
-
What is "Use Level Based Indent" in Comparison report?
Hi all, I cannot find what is the "Use Level Based Indent" update that appears in my comparison report before doing a sync, did anyone encountered it? I have added a small list in the model, but for a lot of modules (that were not using the new list), saved views, Exports, have been recorded changes done to them, with the…
-
Not able to launch a process in UAT environnement
Hello you all. I have a problem, when I put a process on a dashboard, I can run it as long as I am on the Dev environnement. ( I have full access and am a Workspace administrator ). When I switch to UAT environnement, I cannot run the process anymore. Even more, I am able to run the 4 actions separated but not the process…
-
Exporting Time Periods differences for different layout
I know it's written on Anapedia: Date format for Grid export layout is MMM YY while Tabular Single Column is YYYY-MM. But why?
-
Update code of a numbered list
Hello, I want to update the code of a numbered list. The user can input a name on the dashboard. Then I want to set up an import to, for example, import the code to the numbered list but it creates me a new item each time, since we cannot map by name in a numbered list. Any solutions to update code in a numbered list…
-
how to break text into multiple lines
Hi Anaplanners Is there anybody who knows how to break the text values into multiple lines and to make it look easier. By the way to publish it in the Dashboard.Thanks!
-
Converting inputted Date Range into new monthly module
Hey all, I need some advice here. I have a module (no time scale) where one of the attributes of a project is the start and end date (manual input as a date). I want to populate a new module (monthly time scale) with a 1 for each month the project will be active. Any recommendations on a formula to use to do this? Example:…