-
Level 1 Exam question 7 (should the answer be rounded?)
Hi, In response to question 7: What was the total expense for the FY21 executive bonuses in the Americas? the total equals XX.999999999996 do I have to round up? Thank you
-
Can I use the TimeSum with SELECT
Hello Could you help me with the following case please. I have a formula that is using SELECT but in addition to that I need to add a sum controlled by months with some members that I have already created but when using the timesum it generates an error because it conflicts with the SELECT. How could I solve it? The…
-
Spring refresh — Anaplan edition
As you consider the areas in need of a spring refresh in your home or office, it is also a great time to do the same for your Anaplan models. The most difficult part about cleaning is figuring out where to start and selecting the tools and equipment needed to get to the finish line. Let’s break it down into three…
-
Using Delete from List using selection for partial deletion of data for current Month only!!
Dear Community, Needed to check whether is it possible to delete Monthly data using Delete from List using selection for that particular current month. For example if we have data from Jan 2022 to Apr 2022 but we need to delete only the data for month of Apr 2022. How can this action be modified since we can currently…
-
Copy Across and Down on right click of an inputable cell
Currently option for an inputable cell when right click are copy, hide, breakback, sort etc. It would be nice to have the option of Copy Across and Down in dashboards. It is already available on the edit option of the module.
-
Model Optimising and Housekeeping
I'd like to have new features in Anaplan where it will check your whole model and return the following: * Module/Lists which are not references in actions/dashboards and therefore can be removed without impact * Line items which are duplicated in other modules and are using the same dimensions (therefore duplicated can be…
-
History on Formula Changes
Similar to Cell or Module history, there should be an option to get on demand history on formula changes. An option in blueprint mode to select any line item formula and get history option should be added. This will be helpful to track formula change in multiple model builder environments.
-
Include Formula Change Detail in Model History
Currently the model history process only captures that a line item was edited but it doesn't specify if it was a formula change, applies to, etc... and it doesn't include what the formula is/was. This came up recently in trying to research what had happened with a formula that had previously been updated and it's otherwise…
-
Allow for 'Invalid' formulas during model changes
When model building often we get requirements that require changing the dimensions of a line item / changing hierarchy levels etc. Basically things that will break existing formulas. To make these changes to an existing model I'll laboriously go about copying formulas that will break somewhere else, carefully making a note…
-
Built in notepad/clipboard
Hi Anaplanners, This time i am coming with an idea of having a kind of manageable clipboard/notepad built into the development UI. Performing development work i usually have some additional tools like notepad or excel opened on side to able to store formulas or mappings that i want to use in next few mins (example is a…
-
Get dates in different dimensions module
Hi, I have a requirement to pull the dates in the module, the source and the target has different dimensions. Target module Source module I want the dates basis on the revolver in the target since I can't use sum function on the dates to pull it any workaround for this use case.
-
User Selected YTD Time Filter
Hi everyone, Currently have a developed user-selected time filter we use on all of our UX Pages. Driving module: Page/Board Filter: We just implemented the YTD summary yesterday and now I am struggling to get some sort of filter in place where I can check a box and it appears similar to how months, quarters, and years work…
-
Get a total value on other line item
Hi, Can you help me with the next item. I need get the total value of the line item "%" and put in the line item "Pond". in the line item "Pond" is using a LOOKUP but a cant see any value.
-
Get Average of two month on same line item when is Budget
Hi , I want just calculate the moving average for the last two months, however once use the following formula IF ISACTUALVERSION() THEN Revenue actual ELSE movingsum(Average Revenue,-2,0, AVERAGE) Then circular reference error shows up. Could guys give me hand on how can solve these issues? I am looking forward to your…
-
Boolean Check the child list member after checking Parent List members
Hi team, There are four lists L1,L2,L3 and L4 in which L1 is parent of L2, L2 is parent of L3 and L3 is parent of L4. I have a requirement in which I want to mark true all the descendent members if I am marking upper level as true of the list. eg. If L1 have A,B,C members and I am marking A as true then the descendat of A…
-
Time Subsets
I would like to see shorter time periods that we could control for example rolling 90 days, 16 weeks etc. Realizing there would need to be some sort of trigger of control set a start point. A potential user story I need to be able to solve is: I plan by month but need a 90 day outlook As part of that 90 day outlook I need…
-
Level 3 Sprint 1, Build 7.3
Hello, I know this is an example, however I am unable to get these numbers Account Review Module For Small Segment my numbers are: $10,716,645, is anyone having the similar issue? any guidance will be appreciated. Thank you in advance.
-
8.2.2 Activity: Add Volume Inputs Module
I am having a challenge creating the volume input module properly as the location is showing Region. How can I change from the Region format?
-
2.3.9 Activity: Historic Volumes to Baseline Forecast and 2.3.9.1
Hi - Super stuck on Activity 2.3.9 and 2.3.9.1 for the past 3 days. Any help would be much appreciated. Question 1 - for 2.3.9, what am I supposed to do here? The directions or lack thereeof are super unclear. 2. When I'm try to run Action 9, I get this error: "Import into DAT03 Historic Volumes module unsuccessful: Ensure…
-
Hierarchy
Hi Team I am having an hierarchal list (Product L1,L2,L3,L4,L5). I am having a module which is having Product L5 list as dimension. I have published the above module to the dashboard and also published Product L4 list as page selector and synchronized. If user having access to all the hierarchy and user can select any…
-
Lookup by roles and employees & country
Hi guys, As you see in capture 1 we have the Role wise salary details , but i a not able to get these salaries by employee wise , please look capture 3 sys module is there anything i am missing to get releation please help in that to get the employee wise details
-
SELECT AND LOOKUP
Hello Community, anybody to help me, I'm trying to pull data from Module which has Time,Version,Lis as List and Amount as line item in Target module which does not have time and version means it has (Lis and amount as dimension) I'm trying to avoid hard coding {Source Li[SELECT:VERSIONS.ACTUAL,LOOKUP:GLOBAL DRIVE.FY]}.…
-
Level 2 Sprint 2 - 2.3.11.3 Create Line Chart Saved View
Hi there, While creating the saved view for the line chart for my DEM03 Demand Forecast module i noticed that I only have 1 year of data for FY20. The requirement is asking for a view with 2 years of data (FY20 & FY21). I'm looking for some help in getting my formula correct. What i did was i created a new line item in my…
-
Medical Costs-Cert Question
Hi, I have trying to complete the Medical costs for 2 days now and I can figure it out. I created the list of roles: Created EMP003 Employees-imported employees by roles data Added Roles to SYS08 then imported the txt: I try to amend the formula to take in EMP003 annd SYS08 Roles Medical costs - IF Employed? THEN 'EMP003…
-
Previous Function Cut-Off Date
Hello, I have a formula written that takes "Company Churn" / "Previous Revenue" Previous revenue = PREVIOUS(Revenue) The formula works for the individual months, but when it does the summary the rates are incorrect because it always has one month more worth of data in the revenue line item. Is there a way to say "If the…
-
3.3.3.2 Import Data into DAT04 module
Hi, Why would my module be indicating that there are no items in the P3 SKU list? the second screenshot indicates that there is data there.
-
Ratio Summary - Line item & time.
Hello Team, I was wondering that can we have different ratio for line items and time. For ratio as summary in Anaplan we have only one option, which will calculate the same for both line items and Time. Any suggestions, can we have different summaries by any work around. Thanks, Manjunath
-
Remember formula bar settings in new modelling experience
It'd be great if Anaplan could remember formula bar preferences either globally at an account level, or by workspace. At the moment, you will perhaps prefer to set the formula bar to the side view, with a specific width, and when re-opening a new module it will be reset to below the data and at default height. This means,…
-
MROUND showing inconsistent results
Hi, I am trying to use MROUND formula to round to the nearest 100. However, there is some inconsistency that I spotted. original number * multiplier = number to round Example 1: Example 2: Why are the output number different when the "number to round" is the same? I want it to round to the nearest 100. If there number is…
-
2.3.9.1 Import data into DAT03 Historic Volumes module - DAT03 Historic Volumes'.Export" failing
Hello Community, Need your help I am not able to pull the data into the Supply Chain model from the Data Hub model. I get following error. I checked older posts, didn't find a solution for my problem. I have attached all related screenshots. Can someone take a look and advise. 9.1 Import Historic Volumes Model object…