-
Not getting same values in rep04
Can anyone help having issue in getting different value in rep04
-
Anaplan Map Chart of India
Hello Team, Anaplan map chart is very useful display for the users however it's restricted to only few countries in Anaplan. Currently I have few Indian Clients who are actively looking for India map chart. Do we have anything in the pipeline for the same? If not, I would suggest we include that in future release, it will…
-
Activity 3.3.5.1 Create Inventory Ordering Module - multiple issues
I am having multiple issues with the formulas in the Inventory Ordering Module. First of all, I don't understand why I Have 0 as Beginning inventory for Nutzo Bar_En with the formula IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning…
-
What is the major difference between Anaplan connect and actions
I want to know the main difference between using of anaplan connect and actions. What is different between production list and production data. Please give me the information.it will be helpful for me.
-
Option to hide Parent/Summary item in dropdown list
We should have the option to hide the Parent/Summary item when used as dropdown list. Sometimes end users don't prefer to see this as they cannot select these items in the dropdowns list... And this confuses them.
-
What is the best function on the below use case: TimeSum or MovingSum ? (For best performance)
Hi, Generally it is suggested to use the TimeSum function if my target is not dimensioned by time. If my target is dimensioned by time, it is better to use MovingSum. But MovingSum doesn't allow start period parameter other than the number data type. What can we do if my target is dimensioned by time and my start period…
-
Mapping Module no time dimension to time
Hello, I have a csv import that is not dimensioned by time and date in the same cell. It can not be changed for a monthly process import. I am 90% of the way there. I created an import module (not dimensioned by time) and a reporting module that is dimensioned by time. I am able to pull in the data to the reporting module…
-
Text Functions
There should be a function to convert Date to Text -- call it TEXTDATE(x)
-
Drill Through/Link External Source Mapping to a given line item
Be able to list or link to a URL the original source information when there is no deeper level. EG. In a source data module, if drill down is completed the admin has the ability to attach a URL to the source material (if it is an extract/table that was pulled from, view, etc.) and if it is entered having the view/field…
-
Formula error when trying to remove 'Use Switchover'
I have a group of calculated line items that I want to remove the 'Use Switchover' functionality from so they don't pull in Actuals data. However, when I try to untick the box in blueprint mode, I get an error message saying that the formula is invalid. Would be helpful to understand the connection between formula and 'Use…
-
How to calculate within the list items to get the maximun of the items from the first to current?
Hi everybody! Need help to do the calcution within the list. Here is a list with items(#1,#2,#3,...), and properties of Input and Output. The Output is supposed to be the maximun value of the input from #1 to the current item as below table. Anyone has solutions about this? I found it difficult to calculate list…
-
How to Avoid the Top Anaplan Implementation Mistakes, Continued
Back in June, we were so fortunate to have nearly 700 people attend our live session discussing ways to avoid some of the most challenging Anaplan implementation tasks. In this blog, we summarize the top 10 as well as add a few more that were brought up by you during the session. Discover the best ways to prevent the most…
-
Line Item Subsets and Summaries
I'm running into a curious situation where I'm trying to use the Summary of a module that includes a Line Item Subset downstream in another module. I'll walk through the situation below. I built a single module to drive my line item subset, and I created a "top level" or summary item: I created a line item subset that…
-
calculation
Hi experts I have use a list for time dim. and i considered four week in every month . i just want that in first 3 week there is the 7 days in the week and in 4th week there should be rest of day in that particular month . i cant get how we can do this when we used time dim. as a list . suggest me that process I have also…
-
L2 Conculsion Exam Q6
Hi Community, My DEM04 DEMAND EXPORT module has Cell Count of 776,882 cells. I can't get it lower. Can you give me a steer on what I'm missing here please. Thanks, Chris,
-
Modeling advice: How to build item level discounts for set time periods
Looking for help and advice on how to build out a discount function in our model. My company manufactures products and sells them to stores, for this example let's say our customers are Target and Walmart. Our business will give special discounts on specific items (~10 items) for specific time periods, like May 2nd through…
-
modules properties documentation
I am unable to find Anaplan documentation on some module properties like user list, parent, is summary, code, brought forward and start of section and their use cases . It would be great help if anyone has link on documentation related to these properties and ideas on their use case.
-
Option to **** Formula Error Toasting
Most of the modelers know what is wrong with their formula, the moment they press enter and it starts toating system. There should be an option to **** the error processing in case of formula errors.
-
How to do Excel Search in Anaplan
Hi Anaplanners Has anyone built an Excel Search function equivalent in Anaplan? What I would like to replicate is: 1. Client has a text mapping table (screenshot 1) which maps Strings in Column B to their expense classification (Column C & D) 2. SAP extraction which contains a column called Text (screenshot 2) , Column H.…
-
EMP02 Employee Expenses Formula is not working
Hi - I have been trying to calculate bonus, car, phone, and medical costs and the function i input gives me an error message. I am not sure what i am doing wrong. Can someone help me please? Formula for Bonus: IFEmployed?THENSalary * 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Department,…
-
Count the number of users using User list for every months.
Hi All, I would like to take a count of the users using the list Users for every month. I have a module with: Row: Users List Column: Time(Month) Line item : Number(whose formula is 1) I need to sum the number all all the users for a particular month for eg for Jan sum of users can be 74.
-
How to shorten names for a data flat file you use t import into List
Hi, I have a List that will get populated once a month from a flat file that is given to me from IT. The only issue is that some of the naming in the flat file is too long to bring in as a List. And if the name is too long then Anaplan will not bring in that name into the list. I want to know what is the best way to fix…
-
How to ramp up to understanding an Anaplan ecosystem
Hi All, What are best practices / tips to ramp up to an Anaplan ecosystem. I received my Model builder certificate and have a good grasp of the system terminology. I recently was brought on in the middle of an Anaplan project and having difficulty ramping up to what all the build activities that are happening are. My…
-
Avoiding a Circular Reference when pulling the previous day from the same LI
Hi, I'm trying to find a way to pull for the previous day, while skipping over weekends and holiday's, for the same LI. Below is an example of the formula I'm trying to do, but I get a circular reference. This formula works if the LI is from a different module, but I need to be able to pull the previous day for the same LI…
-
Using a subset vs boolean
Hi Everyone, I was wondering if it was possible to have the box to select a subset for list to be shown in the UX? For example I have 2 subsets, CAPEX, and EPMO, among the project request list (where project planners can request projects for the budget cycle) and want them to be able to select if it is a CAPEX or EPMO…
-
Formula Help: Apply Rev. to Earliest Date
Hi, I need to create some logic where revenue that is allocated to a parent, is all placed onto the child with the earliest date associated with it.
-
how to rexecute this correction
Hi Community, Below is the screenshot of the column Revenue Actual CY. As you can see the Net Operating Expense (income) line has a value of 285,480,176. It is the sum of Corp Service Income until Quality Mngt. How can I make the value of Net Operating Expense (Income) the same as the children 71,370,044. I tried replacing…
-
Line item subset for %, Only one line item subset is allowed
Hi Anaplan Community, I want to leverage line item subset to create a summary view of headcount data for the total company. The way headcount is disaggregated varies depending on the business unit (sites, center, SCL) * Site headcount is divided into facility non-enabling functions and facility enabling functions. * Center…
-
FINDITEM multiple columns
Hello All, I was wondering if there is a way we can use FINDITEM to find a value from multiple columns. The way FINDITEM works is by comparing a list with a specific line item (column). However, in this case, I need to be able to find an item that may be in column 1 or column 2 or 3. Is there a way to achieve this? Any…
-
How to achieve Different Granularity in a line item based on the version?
Dear experts, We have a requirement to have to different granularity of data in a same line item based on the version selection. Detailed explanation: The line item has following granularity of data: Version = Actual; then the granularity becomes Potline (Parent of Potline Group, This data comes from Data Hub). Version =…