-
Smaller Time Range | Less than a year Time Range | Day granularity
Anaplanners, I would like to have a time range in a granularity for less than a year. Somewhere between a month or a Quarter. We have a business requirement where we have to import and export working hours for each user per project per DAY. This activity will be monthly and may not be necessary to have more than a month,…
-
DAT.01 module information
I am currently at activity Level 3 Sprint 1 5.2 but looks like I still don't have DAT.01 module. Can anyone tell where can I find details for building this module? Did I miss anything?
-
Changing a workspace name & model names
Hi guys, So I have a question and I hope that you can help me. I have a workspace containing many apps but its name isn't really relevant. Same for some of the apps within this workspace. I want to change their names and I was wondering if there were some risks linked to that change. For example with Datahubs or other…
-
Dependent dropdowns doesn't worked
Hello everyone, I'm asking some help. I have a numbered list "CA0" : This list has two propreties : I want to use the propertie "CA2" in a dropdown list. Here is an example. I create a moudle with two line items : CA0 and CA2 The CA0 line item is formatted like that : Here is the result, I have all my list : Can you tell…
-
Challenge with a fake time list | Data Import | Native time
Anaplanners, Good day ! We are stuck with this peculiar ask from the business and need some guidance on how to proceed with the same. We have a resource planning use case where we have data of the users tagged to a project (this is not based on time). Example User A is tagged to Project Tiger & Project Lion 60% & 40 %…
-
What is Data Management System that was talked about during Anaplan Kick-off this year?
-
Performance Comparison - Direct SUM vs Line Item Subset
Hi all, Was looking to get some community feedback on two different SUM approaches and which one would be more efficient from a model engine point of view. The scenario, I'm looking to SUM line items into a central P&L by account. The source module lines do not have account as a list, so we'll be using something similar to…
-
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…
-
Design a line item with a sequential numbers in it
Hello everyone. I hope you are doing well. I was wondering if someone could help me to design a line item in a module dimensioned by time which generates these numbers from the first column to the end column. The order of numbers and the numbers themselves are as below : 1,2,2,3,3,3,4,4,4,4, 5,5,5,5,5 and so one ( it…
-
Best fit algorithm for bundling/grouping
I have a group of different products having different quantities and want to bundle them in to groups summing up to 10 as close as possible. For example, below I have 11 products and I want to break them in to groups that would have the sum of the quantity equal to or closest to 10. Has anyone tried something like this in…
-
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.
-
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…
-
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…
-
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…
-
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.
-
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…
-
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…
-
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:…
-
How can we create action to load Existing items line item to Applicable Products line item.
This is the screenshot of the module containing both boolean line items.
-
How do I select a prior list item without getting a circular reference
I am trying to build a model that looks like the above screen shot. Tier 1 - Tier 5 are list items and everything in the top row are list items. I am having trouble getting any ending balance to work (for reference, I'm able to begin the tier 2 starting balance and so on and so forth to pull the ending balance from the…
-
Dashboard Default selections
Hi Guys, I am setting up a dashboard for our CFO for financial review. I want to be able to have some default selections done on the page every time he logs in. How do I do that? I am not sure how the selections show up differently every time i open the dashboard. Any help would be appreciated. Thanks, Megha
-
CONCATENATE Formula in anaplan
Hi experts, How to write "concatenate formula" in anaplan. We have 3 proprties in Customer list. I want to concatenate first and second properties into 3rd property. The format of the properties is "Text". Can you please suggest me. Regards, Uma
-
Cumulate function
Hi, How can i calculate the quarter that will fill my ending on hand? Example : I have an ending on hand on Q3 fy20, i need to show in my Output Cumulate the summation of my Q2 fy20 and Q3 fy20 only or the total of 7 instead of 9. Thanks in advance for helping. Tom
-
level 1
how to learn the course
-
Different levels of hierarchy displayed in one line item
Hello everyone I have a problem that I am trying to solve and I would appreciate some help please. I upload a raw figure into line items at two levels of the hierarchy, L1 and L2. L2 list is the child of L1 list. As the figures are calculated outside of Anaplan and have no relationship, they cannot be summarised by a…
-
Plan IQ
Hi all, i have been facing an issue while doing the set up of PlanIQ (followed the tutorial on Anaplan Academy) I am stuck at the same point, when it needs to run the Forecast Action. Do you have any ideas on why it is always displaying the same errors ? I was told to put Internal Access the the list i use (but i didn't…
-
Facing error in line item name referring in formula
Hi Community, We have been working on copied model and trying to replicate the same line items and formulas as well wherein we are facing an error wherein it is reflecting Line item is not identified line item or list member. Example line item name: Historic range? when we refer this name in formula we are facing error…