-
Level 3 Model Builder Starter Model
Hi all, In Level 3 model building, the course says "you will download the Level 3 starter model. The starter model has some of the components already created.". Can anyone let me know where to download the starter model? Thanks,
-
Need Averages of months of prior years
Hi All, I have a situation where I need to get Average value of total sales in Jan17, Jan18, Jan19, Jan20 and Jan21 to be projected into Jan22 in a module. Please can anyone suggest how can I achive this. Thanks, Balarama Krishna
-
Workday function like excel
Hi, I want to use Workday function in Anaplan. It is used in Excel. In this page, we can built using a calculation. But I can not imagine how calculate it. https://help.anaplan.com/d61d7264-24d0-4357-adc6-64701b16c9aa-Excel-comparison:-W-functions Do you have any idea? Date1/11/21/31/41/51/61/71/81/91/101/111/12After 2…
-
Level 2- Sprint 3- INV01 Inventory Ordering Module
Could someone please tell me what I am doing wrong with these formulas. @Misbah 1. Beginning Inventory = IF 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN 'DAT01 Beginning Inventory'.Beginning Inventory ELSE PREVIOUS(Ending Inventory) 2. Submit Purchase Order Request= OFFSET(PO Submitted, Shipping Time Weeks,…
-
Movingsum with boolean item
I want to use movingsum function. But I have a restrict of calender. 1月3日1月4日1月5日1月6日1月7日1月8日1月9日 value300400007000900 Workday☑☑ ☑ ☑ movingsum value2222222 Value(movingsum)14002000 ※Value(movingsum) = Movingsum( value, 0 ,movingsum value) If I used this formula, I can not consider workday. I want to achieve this sum…
-
Level 2 Sprint 3 Activity 3.3.5.5 (Final) Shipping Time Weeks
Hi, This thing is driving me nuts. My formula for "Confirmed PO Delivery" works when referring to the Shipping Time Weeks but won't work when referring to the Final Shipping Time Weeks. Both line items are formatted the same way. ggggrrrrr I would very much appreciate if somebody can tell me what is wrong. Michelle
-
Running total, No Timescale
Hi, I am in need of a solution to this dilemma and being new to Anaplan I can't think of way to write the formulas. The goal is to be able to pro-rate actual days work from days on leave. The PRO rate module has emp ID list and month time scale as the dimension and a whole host of line items to calculate start and end. And…
-
Enhanced Hotkey support across Anaplan
Some users prefer mouse, while others prefer hotkeys, and some like a mix somewhere between. Curently Anaplan feels 95% built around mouse-users, while keyboard users have a very low number of hotkeys to fall back on. Anaplan users would get a lot benefit if the platform considered hotkey use cases to be equally as…
-
Current Period Filtering for List
Hi Anaplan Community, I am interested in filtering a list in a saved view, based on the current period, for dashboards we are converting to new UX. So, for example, I have a list of locations that are charged a certain percentage for occupancy and my grid is showing the percentage each location is charged each month…
-
Determining A Line Item By Reference to Other Line Items
Hi all, I'm trying to do something that I think SHOULD work but I can't get it quite straight in my head so I'd appreciate some support. I've got a module that's holding employee data, dimensioned by Employee ID and by month. I need to be able to identify people managers, but the data extract doesn't have a flag for that.…
-
New Modelling Experience
There are so many things that I loved about new modelling experience but here are my top two picks which I loved the most. 1. Ability to open Lists, Line Item Subsets, Modules and Dashboards in their own tabs. This removes the need to go back and forth between Modules->Lists->Line item subsets. 2. Line item Subsets(LIS),…
-
Restrict access for import
Hi, I'm trying to amend the UX page for my organization. in the UX page, each user can import data into 'General expense' line item. After they import, they are able to check and view what they have imported. How can I set the access such that each person is only able to view and check the numbers they have uploaded…
-
how to add module
Hi All, I got access to the anaplan but my home page doesnt show anything even i am unable to add a new module as there is no option showing. Pl help. Regds, Chetan
-
Calculate the number of complete months between two dates (Similar to Excel DATEDIF Function)
Hello Community! Is there a way to calculate the number of complete months between two dates in Anaplan? E.g. Start Date (MM/DD/YYYY)End Date (MM/DD/YYYY)Number of Complete Months07/17/202007/16/20211212/03/202103/31/2022310/1/202112/31/20213 In the second row, even though the duration between 12/03/2021 & 03/31/2022 is 3…
-
How to find monthly average of Daily Totals?
I want to create the average of every month of a LI that displays Daily totals. One of the LI's will be my total account balances on a daily bases, and then I would want to create another LI that would show me the average of those daily total for each month. How would I go about this? Thank you
-
Module Selection for Line Item Subset With >1000 Modules
We have encountered a bug where if there are more than 1000 modules in a model, the panel where you select a module(s) to assign to a line item subset does not work. There is a workaround available (provided by Anaplan support to us about a year ago) where we can look at the web-page elements and find the code for the…
-
LOOKUP function with a version module
Hello all, I am facing a situation that seems weird to me. In a module, I want to repatriate the value of a forecast made last month. So I create a line item that uses the LOOKUP function : previous Fcst = Fcst Qty[LOOKUP: Param Version.Previous Version], Param Version is a system module that manages versions. It seems to…
-
Dynamic ranking not working
Hi Community, I am trying to rank based on concatenation of two dimensions and rank doesn't seem to be working. However, when I remove "group by" condition from rank formula, it ranks. Why is it so? Can somebody explain please? Thanks Alka
-
Understanding data referencing in Anaplan
Hello All, I am unable to understand how Anaplan is using data referencing. Please see the below scenario. I have to create a system module with product SKU details. I am using SKU Flat list as dimension and Code,Products and Distribution Center as Line item. I have imported the data from a CSV file and it looks like this.…
-
2.3.10 Activity: Create Demand Forecast
Plz can someone let me know are these formulas correct to go further in the assignment
-
Start function returning start of the week when I pass a Month period as a parameter
When I apply the Start function below against a Month period it returns the week period start instead of the start of the month for the month period. The calendar setting has calendar type set as week which I guess is the reason it's returning the start of the week. Is there an easy way or another function to that will…
-
A Good Plan: Spend Time on User Stories
In this guest blog series, Anaplan partner Spaulding Ridge examines what they have found to be integral parts of a good plan: the level of detail, the process, the people involved, the timing, and pitfalls to avoid. Writing user stories is one of the most impactful and exciting phases of the early Anaplan implementation…
-
Import Shipping Expenses into OTH01 Module
Hi, I am getting the below error. Here is my mapping What am I missing? Appreciate the guidance here.
-
Ability to generate a simplified scheme presenting all the direct interdependencies of a module
As a model builder, I need to be able to see quickly, for one given module, all the interdependencies with other modules of the model, both upstream and downstream. I need to be able to add or remove elements from the generated scheme if needed. I also need to publish it in a dashboard. The scheme elements will be linked…
-
Mapping Data from one module to another
Hi Everyone, Please consider following example, NameTypeAZPBRBZRBRCZRCLDZWIR I have a module A with 'Name" as list and a line item named type as shown above, now below I have a second module B with a List "Class" and the list "Name" in module A is a line item here. ClassName TypeABDA SHGB AJSC How can I bring the values in…
-
why DCA for formula based line item?
Hi All, Downloaded the DCA App from App Hub and looking through the examples. Have a question in regard to below screenshot, 2 lines in module, both have formula which means no user input and in effect read only, and yet DCA read write has been set up, what is the purpose? not clear. Anyway user can't input since populated…
-
Level 1 Model Building Exam Activtiy 5 -- unable to calculate right formulas
Hi, Can anyone please suggest to me what is the mistake I'm making here? Q:
-
2.3.9.1 Import data into DAT03 Historic Volumes module
hi in this run process in getting as below picture. Can u help in this
-
General Questions
Hello, I currently try to take a Anaplan lvl 1 Model building class and I don't have any accessibility to Anaplan system(Current company doesn't use). I applied for 90 days trials(I read that I need this) and Anaplan activated my account for access. From this point, I don't know how to start my course, can I start my…
-
Level 1 Exam Activity 5 - import txt data error
Hi All, I'm stuck and getting multiple errors when trying to upload the SYS08 txt file for activity 5. I saw another forum to not change the txt file to csv and to map e2 to code, but I'm still receiving errors. Do you know of any reasons why this error is persisting? I've provided screenshots attached. Also, anaplan did…