-
How to identify the Top Level item in a Module
Dear All, I have a requirement to show elements belonging the Top Level item in my Module, but unfortunately i cannot identify the Top Level Item, since i am unable to capture any of the properties (or) Attributes of Top Level item. Top Level item is defined in Level 1 Level 1 is parent of Level 2 Level 2 is parent of…
-
Formula - Previous?
Hi, I have a module that shows the full-year forecast amount for various expense categories. It also compares the current forecast (2021) to the prior forecast using the formula PREVIOUS(Full year forecast). That was fine in 2020, but now we are in 2021, the prior forecast shows nil. How can I fix this so it picks up the…
-
Rounding not correct in ALL
Hi, Do you know why I'm getting wrong value on Total Containers for ALL for Inbound Pallets (see image)? For example: W/c 18th Jan 21 should be 4 and not 3. I suppose the 3 is based on 1.159 + 1.159 = 2.318 so rounds to 3. But I want it to be based on the already rounded 2 value. I can't use SUM in the Total Containers…
-
Treatment of duplicated identifiers in target
How Treatment of duplicated identifiers in target works? I set it up "Reject entire import" But I see that List is getting updated? Can you please provide an example? @Misbah
-
summing up prior year data
Hi, Question please. I am trying to sum up all the values in the Depreciation line item column for prior years 2020 in my calc module by company. However, I'm having a difficulty to get all the previous years data and sum it up. Thank you.
-
weekday function
Hi, After using my weekday function, I got the number to display. Now how do I get The actual day of the week to display verses the number of the day of the week? Thank you
-
Calculation with different dimensions
Hi, I have 2 modules : one with the headcount and the other one with average salaries. I want to create a third module with total salaries (which is headcount*average salary). But, in the headcount module I have the headcount with line items internal vs external, and for salaries I have salary as line item. How can I…
-
isfirtstoccurrence formula
Hi, question please. I need to get the first data(#1), hence I used the isfirstoccurrence but not sure on why the #2,#133 and #362 are also checked in the boolean? Thank you.
-
Subset not populated from module boolean import
Hi, I have a numbered list of Employees that I've created 2 subsets for: Hiring Manager Approval Manager So I created a module with the list as dimension and then boolean line items used to fill in for hiring and approving managers, and then import those module line items to the list to populate the subsets. For some…
-
Uploading into Anaplan - YTD
Hi, I have a module where I'm uploading YTD actuals into Anaplan. Does Anaplan know it's YTD actuals, rather than values for that month? How do I tell Anaplan to take the last upload, and ignore the previous ones? Thanks
-
New article: Decreasing Formula length
All, Just wanted to point you to a new article on using line item subsets to decrease your formula length. You can find it here: https://community.anaplan.com/t5/Best-Practices/Decreasing-the-Length-of-Your-Formulas/ta-p/88467 Please let me know if you have any questions, Rob
-
Product List - best way to not show products which are no longer active?
Hi, I have a number of lists e.g. product list or employees list, but how is it best to maintain these as the list keeps growing, but we have products which are no longer active or employees who have since left? Thanks
-
NUX - chart - combination graph
Hi, Is it possible to create a combination chart in the NUX which combines all 3 charts in 1? I tried earlier and I was not able to align the dots across each bar chart? They were all clustered together. Any ideas? Thanks
-
Self learning / training for certification
Hi I worked previously in Anaplan implementation projects and would like to get myself self trained in Anaplan. I dont have any Org who can provide anaplan credentials. is there a way to get anaplan credentials for training/ learning purpose
-
Yearly ESCALATION calculation
Hi, would like to ask on how can show the escalation yearly amount? for example FY21, the amount is 10M and for FY22 the amount should be 10M x 1.1 = 11M. Please see screenshots below. Thank you anaplan excel: should be amount
-
Building a Cash Flow Model (Need Advice)
Hi, So I'm playing around with trying to build a Cash Flow Model in Anaplan that is on a Daily Time Scale [WeekDay Function I plan to use] and has Line Items of different Accounts in the company that must stay at a min/max balance daily. I want to try and make this an Model that will automatically allocate the money around…
-
Bi-weekly Pay Period Management
Dear Community, My budget model's calendar type is Month/Quarter/Years but I need to do some calculations by bi-weekly pay periods and then roll up the result (using SUM) to month. Our payroll calendar varies by year. I created a Pay Period Lists and a management module to map the Pay Period to the Month and Year it…
-
NUX - Adjusting size of line items
Hi, Is it possible to adjust the size of a text field? I can hover and see further comments but is there a way to show more than 1 line by adjusting rows? Thanks
-
Filtering by Line Item (List)
Hi, I have created a filter to my module where users can select an item from the filter, which the module will then show those which apply (via boolean). However, I cannot seem to show all items? I created a top hierarchy in the list, but my boolean formula is S_Reporting Group Selector.Reporting Group Selector = Reporting…
-
Need help with Selective access problem
Hi, I have a custom user list and a another dimension called B with 10 members. There is a input grid where user list is in pages and List B is in the list formatted line item, I want as per each user they should only see few members of list B in the line item in input grid and it is many to many mapping between user list…
-
Formula help needed
Hi , I have 2 lists, List 1 and list 2. I have a module with line items List 1 code, List 2 code and type and applies to as List1.. The values are as below. I have another module with applies to as list 2. I need to pull in items of Type A into line item 1 and Type B into line item 2 based on the List 2 code. Please can…
-
Hierarchy
Hi, I have a list of products, with Country as Parent. Each product also belongs to a specific reporting group (which I've included as a line item in a Product Details module). I need to create a report which is categorised by reporting group (with products under each). However, looks like you can only have 1 parent? Is…
-
Exporting into multiple files/tabs
Hi, I have a module that is dimensioned by product. I would like to export this module for each product in a single excel workbook, with each product on a new tab. Is this possible? Thanks
-
How to add a Dimension to your your Module that has already been made?
Hi, I created a Module and forgot to add a List as one of my dimensions to the Module. I need to know how to add the List Item to my Module without deleting it and starting all over again? Please advice. Thank you
-
X[Min:y] doesn't return results consistently
Hi, In the first screenshot below, the formula in Min Start Date TEST is trying to get the earliest Activity Start Date by line item Campaign New from the second screenshot. There is no empty date in second screenshot, but the formula returns nothing in the first screenshot. This formula works in most other campaigns in…
-
Text formatted line item duplication
Hi, I have a line item which is text formatted. User enters values like Apple, mango and apple again. For the 3rd value(apple)- it should show me an msg pop up, that it exists already. Please can anyone help me on how to write logic for line item 2. Regards, Rajasekhar
-
How can I get hands on training on Sales Performance Management modules
Hi , Would like to know the learning path for Sales Performance Management. Is there a way I can simulate sales plan, quota setting, forecasting in a test environment? Thanks in advance. Murali
-
Allowing circular references
I have a case where I want to allow Anaplan to make circular references, what do I want to do? Basically to make a coffee I need: 1 Cup 1 cookie 50 grams of flour 5 grams of butter ... 150 ml of coffee 160 ml of water 3 grams of coffee powder So when I needs 2 cups of coffee I can go down the "hierarchy" and calculate how…
-
How to show only the last uploaded data from a module in a dashboard
Dear Community, Could anyone please help me to implement a requirement? We are getting a monthly file from various manf. locations that tells the available inventory bucket values for various product lots. Here is a sample of the file we are getting I am loading the file every month to a Data module dimensioned by…
-
Level 1 model building exam - model building activity 2
Hello. Can anybody help? I struggle with the Level 1 model building exam. "in the level 1 model , update the REV02 volume inputs module to include a formula to pull data from the DATA 02 SKU Volumes module".