-
Need a filter toggle to show data for all 12 months or only the year
Hi I need a filter to toggle between showing all 12 months of data from jan to december or just the FY data essentially to show hide columns. I have been trying for a while and am not sure how to do this for example show only fy22 or all 12 months like in the screenshot above
-
G4T territory
Can anyone please share screenshot of this list. I am trying to upload CYW file, but its not working. Please advise. Thanks -Pooja
-
FP&A Budget Allocation Best Practice
Hi All Wanted to make sure I am thinking about the infrastructure of our Anaplan build correctly. We are going to build driver models which are going to contain the line item detail and dimensions which will be summarized into our spoke models which then in turn will be further summarized in a consolidation model. This…
-
Carry forward a value over several months
Hello fellow Anaplanners, I'm working on a module that has an Approved FTE by month. But the user can go adjust it through a form and add/subract FTEs as needed. It is working great for the current month. Meaning( Mar 2023 has 2 FTE for Job A. User adds 1 more for Mar 2023. I have a Final FTE line item that sums the 2 and…
-
Level 2 Sprint 3 Ending Inventory
Hi, I am getting circular referencing error when use the formula to calculate the ending inventory as follows: Ending Inventory = Beginning Inventory + Confrim Purchase Order Receipt- Forecast Demand Error Message: Circular references: Ending Inventory, Safety Stock Exception Count, Confirm Purchase Order Receipt,…
-
Automatic import of failure dump
I have an action that imports data from excel into Anaplan. When the data fails to load, it is due to a missing list item (a project). When the items fail, I would like to extract the failure dump, and import those projects into another table, which heads off an import action that brings these missing projects into the…
-
Aggregation of values based on the same list values
Both has same dimesion . now where ever the alternative the should be input by user and default is calculated based on then alternative i means . if alternatives have 20 and 30 the default should be 20+30-100. if mean default is 100. when ever they enter the aternatives default should be minus from them
-
Firstnonblank formula not working
Hi, I'm trying to create a line item with the "firstnonblank" formula but it's not working. I have 3 line item : * line item 1 = hub (let's say "1"or "2") * line item 2 = some text but not everywhere * line item 3 : i want to have the text of line item 2 but for each item in the same hub I join a screen which is way more…
-
Aggregate from a source module to a module with common but less dimensions
Hello, I somehow struggle to find an answer to this problem: I have my line item "Sales" in Module 1, which is formatted with Dimensions A, B, C, D and Time (Year) and I want to aggregate these sales in the line item "Aggregated Sales" in Module 2 which is formatted with Dimensions A and B only (no time format). Could…
-
RATE formula help
Hi, I am trying to replicate the Excel formula RATE in Anaplan. It seems to work for Q4, but not for the rest of the quarters. The excel formula is: =RATE(FRAC,,-$C$30,H30) where -C$30 is -100 and H30 is Total Return Index for that period. I have created below in Anaplan: Why am I getting different returns? Thanks
-
Delete orphan records from a Properties module
Hello all, I want to change the rollups of Cost Center into its parent Division in hierarchy (i.e. Cost Center 100 belongs to Div 1 today. I want to change to Div 2). I can make teh change and write the data correctly. But I can't think of an automated way to delete 2 levels of hierarchy under the existing cost center.…
-
Aggregate data based on dimesions
In source module i want to select the Defalult and alterenative is input. based on that target module percentage should calculate(if it is bdefault the 1(100% ) else balank) . now i am getting error mismatched levels how to go about it
-
Manual Entry for Cells
Hello, I have a question in regards to manual entries in a schedule. I have a schedule below and for the three highlighted line items, users should be able to enter manual entries but they are not. Can anyone provide guidance on how I would go about unlocking these cells for line items so they can be editable?
-
Restore model when its in deployed mode
hello team members, I have attached a screenshot where I am getting error to restore my model. I have archived this model and copy archive. Does deployed mode cause any effect?
-
How do I have a different summary method for a single line item?
I have three line items: budget, reforecast, and variance. My dimensions are three different lists - type, subtype & quarters. Some of the subtypes for budget and variance need to be sums and others are closing balance. What would be the most efficient way to do this?
-
How can I create a dashboard for a interview and import data from get hub?
I have an interview upcoming and have been asked to created a Anaplan dashboard. I cant seem to find where to create one or any updated forums! I just want to know where I can go Anaplan itself, or Anaplan community that will allow me to create a dashbpard and inport my Gethub data from there. Thank you!
-
Inventory Age Calculation Optimization
Hi Everyone, I am working through a calculation where we are trying to determine the average age of our inventory backlog each day in time. We are using FIFO to determine what inventory is processed first. If in Day 3 I have 1000 1 day old widgets and 500 2 day old widgets, and I have the capacity to process 750 widgets,…
-
Issue with changing Numbered List in Production to composite hierarchy
Hi everyone, I have a composite list which is set as production List in production model. It has 5 levels of hierarchy the 3 lower levels are numbered list. Due to customer request, changes need to be made to make the list a non-numbered list. I have amended it in the DEV as non numbered list but when synced to PROD it is…
-
Why for same list format line item available options are different in dashboard and NUX ?
I have a list type line item and its filter are Selective Access and Dependent. It is deployed on both tradition dashboard and NUX in same saved view. There are 3 available options(item) can be selected under this line item, and in traditional dashboard all 3 options can be "read" but only one can be selected. In NUX, all…
-
How to create Module for List
I want to migrate DBs to UX pages and in DBs there are Hierarchical DBs so to create UX pages for that Heirarchical list i have to create modules. so my question is when i am going to create module so in list there is one parent item and another one is child Item, i created one module but when i saw there is no info for…
-
Revenue from companies within the same consolidation group are not eliminated properly.
I have an issue with my Anaplan model. Revenue from companies within the same consolidation group are not eliminated properly. Can you help me troubleshoot this issue?
-
Bring a value based on summary method
Hello, I am trying to create a line item where I specify which product was sold the most by each of my sales reps. Rep and Product are lists on my model. I have a module called "Sales history" where I have the sales of each rep for each product. I want to have a module where I can select a rep and the line item (let's call…
-
Need to lookup multiple items from another module
I have a module with PO numbers 1 line per PO, with space for 4 product codes The source list is from a simple PO list, with no details, i can then get the details of shipping etc using a lookup Inbound Stock Transactions.P_Forwarder[LOOKUP: PO] etc But the source data has mutiple lines, one for each product, which i also…
-
In anaplan model testing , Is it possible to do automated testing?
What are the tools we may use to test anaplan ?
-
Previous/Lag Function Not Working
Hi, I have 2 line item and on the other line item I used a Previous() function to try and get the last actuals value to spread it in forecast but it seems to not work, I also tried LAG() and same issue. What could possibly be the issue or is there a workaround on this please? Below is the module, it is dimensioned by 2…
-
level 1 model building
Can someone please help me correct what I am doing wrong. I imported the employee.csv file but not all the columns came over into my model.
-
How to make text rollup's at top level in hierarchy as blank and visible at other levels.
Hi Everyone, I am looking for a solution for text rollup's in summary in hierarchy. I have a model with 4 levels of hierarchy. In a module , I am using L4 Product list as Dimension. There I have added a Text Format Line item called " Client name" with summary as First Non blank. It contains formula to Identify which…
-
Data Import Integration
Hello, I have a question for my understanding on data import integration. When data is being imported from a database, source, etc how does Anaplan remove duplicate data from WS02 and are there any specific requirements on the sequence of data, or does that depend on the organization? How does Anaplan remove duplicate data?
-
Why am i getting this when trying to import to a ticked production data (numbered) list?
"Deployed Mode is enabled for this model. You do not have permission to change structural data." it is ticked production data and i am just importing data to it, only 2 fields. I am the builder and have FULL access to everything I am not changing structure i am importing data
-
How to Read back from a consolidated module
Hi Experts! I have a module A using below dimensions - Sales Territory Quota Mapping list is a list with sequence numbers from P1 to P6000. there are properties like Employee (using list of EmployeeAssignment) and Employee ID in this module. And a module B like below, where I consolidated/summed the numbers by…