-
Allow for Copy/Paste of 'Reverenced By' to work in 'Model Search'
The new 'Model Search' is awesome! I use it all the time! I have noticed that it cannot handle a few search prompts. One of them is if the user pastes a full reference for a Line Item. An example might be 'CALC Store O4 Month Results'.Store Hours Threshold Pasting this in Model Search produces no hits. But the ideal result…
-
There has to be a better way. Any ideas?
Hello, While on a rebuilding project with a client, I am ready to delete some modules. Problem is the line items in those modules are used in Formulas and are connected to downstream modules. I know I can reference the specific references in the Blueprint view, and scrolling over to see the Referenced By column. However,…
-
Avoiding a large intermediary module
I have a list of transaction codes that a user wants to summarize in a report that replicates what they've produced in excel. The transaction codes don't form a natural hierarchy for this. The excel report pulls out various individual codes, groups some together, summarises others etc. To achieve this I've got a line item…
-
How to get first date of the model
Hi, Does anyone knows how to get the first date of the model? *The first date that comes from the time dimension I want to compare the first date of the model against date input by user.
-
Increase 1 million list item limit for Order list action
Requesting to increase the limit of 1 million list item count for Order list action. Currently we will get the following error when list item is over 1 million: Cannot Run ActionThe number of items in the list (1000001) exceeds the maximum allowed (1000000)
-
13.6.5 Activity: Add Column Chart to Margin Summary Page
Hello! I have the problem - i filtered the data with the rules given (forecasted months only), but i can't get the view needed The picture is below what i have What i need Also i notice that my view in the grid chart is also not correct - but when i changed it does not give me the chance to save with the same name What is…
-
Level 2 1.3.6.3 Create Build Location Saved View and 1.3.10.4 Check Your Work
Can anyone explain why I'm not getting the view as displayed in the instructions? My screenshots show my saved view, the view after the import, and what it should look like. Thanks!
-
Need to know why getting Circular Reference
Hi, I'm adding my "Inta Month Growth" LI to the formula I have in the "Less:Ineligibles" LI and getting a circular reference. I can not seem to find the root cause of the circular reference. Please advise. Thank you LI "intra Month Growth" Formula LI "Less Ineligibles" Formula The Circular Reference I receive when adding…
-
Improved History Granularity in History Report
Description of the enhancement requested: When the client exports the history they want to see the details on who changed the Formula, as well as having an ability to filter out the needed modules, lines, etc. The output is there but they want to be able to filter it online as it is close to impossible to do in…
-
% Percentage
Hi Team, Wanted to confirm if the below screenshot is correct? In my module, calculations are working but why is it coming as 105% in the screenshot - Check your build Thanks
-
10.2.4 Activity: Import Data into Employee Drivers Module
Hii after mapping successfully, Bonus % showing 0 value
-
How to calculate the YoY growth in line item
I have Year wise numbers in my line item in a module, now i want to calculate the Year by year growth in between years. I want to calculate FY21 YoY = FY21 Productivity growth / Fy20 Productivity Growth. FY21 YoY= 2.55% Please suggest me how get the result.
-
Tell us what your teammates need from your dashboards
As an Anaplan user tasked with helping your teams better understand their data through your Anaplan UX dashboards, we want to hear more about what your end users tell you. What kinds of visualizations are they are asking you for, what do they struggle with in accessing and understanding your data, and how you resolve those…
-
GUIDE: February 2021 Release | Time Stamp on Actions
Community, Just a quick heads up. Every time you run an action you will now see the timestamp on the action tab. Awesome! Here's an example of a manual action being run. I tested it on automated actions too and it works great. Thank you Anaplan - huge win!
-
What are the limitations of the Notify Actions (Static & Dynamic Recipient setup)?
Hello, Anaplan community! I'm curious to know, what have you identified as a limitation or constraint of the Notify Action?
-
Excel Add-in and Updating the Data Model
Hello, I've built out some Planning worksheets using the Anaplan Add-in and I'm noticing that when a new member is added (for example, a new GL account), the sheet has to be refreshed in order to function. I'm writing to see if this is regular behaviour and that I should expect to always have to refresh and use the latest…
-
Workspace request
Hello, Can you please advise where I can apply for 90 days workspace? There is no button APPLY. Regards, Telman
-
if formula question
Hi I'm trying to make formula but it's not going well IF ステータス = 承認済み THEN TRUE ELSE FALSE how can i make this formula? I need your help... please help me
-
Incoherent summary when period is quarters, year or even YTD
Hello, I'm really at the beginning of the journey of being Model Builder so I'm afraid that what I'm to ask you is really basic, but hope to find help and the learn more :) . The context of the issue is that the following line item is looking for the customers that have 0 revenue in the current month, and if is true, then…
-
How to download model from my anaplan workspace
I would like to download my workspace models, can someone help me out of it
-
Level 3 - User story 1.5 Initial Account Sales Targets
I am trying to achieve the result like this: but once I finished in the anaplan, it looks like this: You can see the total is identical with the training material, but if we check "Candyate", they have some gap. I am sure the target is correct, the issue should come from revenue I guess. I track all my modules, here are…
-
Team Up Feasibility Calculation by Optimizer
Hi Community, I am working on a simple team member setting model using optimizer but it keeps returning "The problem is infeasible" error. Here is my model: - The module consist of a Nurse List and a Doctor List. It has three line items : Team, Success, and Team Up Constrain. Team - It is the variable for optimizer. In…
-
Formula Help
Hi, Need help on creating a formula where it takes a input % for the month, and if a End User wants to change that % then they can and that % will run through the End of the Month. Having trouble making that daily input % run through for the rest of the month. Formula is below
-
Lookup Mapping
Hello Experts , I just Want To Take Data from (Increment by Product family) to (increment By product) For this I used Lookup Function ex Increment by Product family[lookup: Product family] formula apply successfully but did not get any value . can u help me Remember Product is the child of product family Thanks in advance
-
Another Question
Good Afternoon, I am yet getting another error... Data type mismatch: format other than LIST or DATE being referenced as a relation Anyone what this mean? Thanks Tony
-
how to hide the unique identifier when we duplicate a display name in a numbered list
For eg. I have two line items display name as Brazil here as an example. I want both of them to be displayed as Brazil only and not Brazil(#17) & Brazil(#18) in the Tree View. The issue is only in the Tree view. When we use this list in a module, the display name is shown as Brazil only. The issue stands in the Tree view…
-
Aggregate value of lineitem
Hi team, I need to aggregate of a line item-1 with number of accounts and display in another lineitem2 in same module. Line Item 1 - Total Sales Revenue by Account (Each product family has number of accounts under it) LineItem 2 Total Revenue by Country = SUM of account sales target of all the accounts coming under that…
-
Pro tips: Troubleshooting calculations
The Anaplan team is always looking for stories of Anaplan in action, seasonal planning tips and tricks, and use case-specific studies on how to best use the product. Recently, Stephen Rituper and I (both from our Operational Excellence Group) sat down with a few top Master Anaplanners to hear from them on their specific…
-
How to use “SUM” function in Anaplan: Explanation Through an Example
Hello Anaplan Community, During my Level-I and Level-II trainings I thought that it would be useful if an explanation with an detailed simulation for use of LOOKUP and SUM functions. There for I prepared a detailed explanation for each functions. Below you can find the explanation with an detailed simulation for use of SUM…
-
Level 1 Activity 9.2.3 Revenue decimals ?
While double checking some of my summary and formulas, I noticed that in Rev03 Margin Calculations I have decimals in my totals. However, in the verification screenshot there are no decimals. I checked the formula for Revenue and it is set to Number>with No-decimals. I checked the formula for the References in the line…