-
LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build
Hi, I have tried almost everything and have been stuck on this part of the model build or a day now. I have changed my dimensioned and tried to get them to match and still not working. I'm trying to pull in Actuals from the DAT 01 into the DAT02 and Looking up LT Account A1 inthe SYS03 Module. Please advise. Thank you…
-
Switchover, use it or build your own?
Hi All - In the context of an FP&A use case, we're trying to evaluate whether to use switchover or just build a system module to dictate where the forecast begins and the actuals end. Would love to hear about pros and cons of both approaches. Here's what I have so far: Pros of using native switchover: 1) Ability to use…
-
Getting an error for a user who is not a workspace adm
A process updates a numbered list from a saved view (Module.Saved view) -> (Updates List name, parent, code and few properties) When workspace admins run this process, it completes successfully with errors only for duplicates When a user is not an admin runs the process however, the following errors appear: * You are not…
-
P&L Variance List
Hi, Question please. What is the best practice if I need both the columns and rows as a line item because I need to calculate the variances and the difference to maintain the clients preference on the presentation. Below is an example. thank you.
-
Demand Forecasting
Dear Community, I am trying to build a system with 2 regional sales manager and one sales head. Regional sales managers should be able to submit their projected numbers and sales head should be able to see, who has submitted and what have they submitted in the Anaplan. Do we have any courses around this in the community or…
-
DATA02 import issues
I am struggling to import data over to the DATA02 module. I believe I have the right options selected. I am just not sure why its not populating all the data.
-
Level 1 Model Building - Lesson 8.6.4
Hi Community I have included the formula as requested into the formula line of Revenue however it's giving me the attached ERROR MESSAGE which I can't seem to rectify. Any assistance regarding this would be greatly appreciated. regards
-
Sum all values in a time series up to the current date
Is there a way to use TIMESUM or MOVINGSUM to sum all values in a time series up to the current date? Essentially creating an 'inception to date' calculation. For example, if I have a monthly time series with the values 1,2,3,4,5 then I want my inception to date calculation to return 1,3,6,10,15. I can achieve this by…
-
Is it possible to show or hide the parent hierarchy?
Is it possible to hide B in the following hierarchy? My hope is to hide B and show A and C. <Sample> A(parent hierarchy) →B(parent hierarchy) →C(Child)
-
Select Function
Hi Community, I am trying to use select function with an list member, but it is not working at all. Is there anything that i need to enable as a part of setting? Thanks & Regards Badam
-
Level 1 Importing Into Modules and Making Edits
I'm on Level Lessson 7 and there are multiple activities where I have to import data from csv file. Is there a way to make edits to mapping after data has been imported already or do you have to start from scratch? In general is there a way to undo mistakes in Anaplan? Tried ctrl z but it does not work.
-
Line Item Restriction
Hi Community, Can we restrict the user to enter only positive numbers in a line item? And if he enters anything apart from the it should also throw some text, displaying only positive numbers are allowed? Thanks a lot for your support 🙂
-
L2 Sprint 3 Distribution center capacity module
Hello Can someone please double check the formulas used for this module, its showing percentage for more than 100%. Is that normal? Please help me correct if there is any error in formula. Thank you!
-
Format of mapping used for lookup doesn't match any dimension of the source
Hi all, I've looked through several of the queries/answers on this topic and still can't work out what I am doing wrong... I am trying to provide a summary of employee expenses by region and role in REP04; I am trying to use EMP02 as my source as this has employee expenses by employee and department. As there is no direct…
-
System Modules
Dear Community, @rob_marshallJaredDolich Why does most of the Anaplan Modules in the App Hub: Such as Long Range Planning is not using System module creation and directly jumping to data / input / calculation modules? It is going to impact the module sanctity right?, Your expert views would be highly appreciable. Thanks &…
-
Grid:_onSelection Change Error
Does anyone know why this error occurs? It is typically when I am building a formula then click on a different module.
-
How to use SUM and LOOKUP dynamically
I have Order module(Region, Order) Order(1,2...) comes from each Region. Order has Item and Amount. I want to aggregate item-amount by dynamic Region like this table. If Users chose the Europe, Item-Amount Table is aggregated by Europe. I tried SUM and LOOKUP but I couldn't. The point is I don't need Region List in…
-
Creating new line items for each year instead of using native time?
Hi All, I recently took over a few models that make use of a month list and separate line items for each year instead of Anaplan's native time functionality. I was told the models were built this way because end users didn't find the dashboards to be intuitive and this was a means to improve the user experience. Here's an…
-
Formula Logic Help
Hi guys, Got a question I need assistance with. I have a number of lists that follow a hierarchical list, account level 4, 3, 2 ,1. At level 4 each account also belongs to an accounting group (online, local etc) and has a signage value of either 1 or -1. The accounting group and signage are contained within a module called…
-
Formula - What am I doing wrong?
-
Best Practices for creating a formula dealing with SELECT
Hi, We are trying to create a formula that will subtract the sum of all the List Items, (excluding List Item 'Other'), from the overall Total of all the List Item totals added together. We were thinking of using the SELECT function to pull in the amounts for each List Items and then summing those all together in a SYS…
-
DEMO 03 Demand Forecast. Weeks(All week issues)
why all weeks are visible to me for 2020 . Rather than 4 Weeks ??? Thanks & Regards
-
Ratio of what % each child makes up of parent
Hello, I am attempting to calculate the % of a parent forecast each child makes up in a given time period. For example, a month has a 100 unit forecast in America. Texas makes up 60 units and California makes up 40 units (both children of America in a list). I am trying to show this: Texas 60% California 40% America 100% I…
-
New Model Experience: Not able to fully view formula bar when model is deployed
Hello, while I can open the formula bar in an ALM Dev model - I cannot do the same on any Test Environment (or the live environment). This is making very difficult to debug any issues on a deployed enviroment (need to check the formula in Dev which might have already changed) by another developer. Not too sure if this is…
-
Most used Planning Models in an Organization
Hi Anaplan, @JaredDolich @Misbah @rob_marshall @MelanieM What are the most used Anaplan Planning models across different sectors, especially in the following domains: 1. Financial Planning and Analysis 2. Sales & Operations Planning So, will try to learn more about the same for execution. Thanks & Regards Badam
-
3 months average of historical sales the year before
Hi, I need to calculate the three months average based on the historical sales data the year before. For ex: Jan 20 Feb 20 Mar 20 - Average values should go under Jan 21. 100,0,100 - 66.7 Jan 21 value Please could you suggest the optimal solution for the same? I have attached the screenshots for reference
-
Level 2 - Sprint 2 : Activity 2.3.9.2 Update Historic Volumes for Baseline Forecast
Hi, In this activity my formula is IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 . My result is 0, I don't know whether it is right or wrong. Can somebody please confirm this. Attaching the screenshot. Thank You very much.
-
Formula help on counting a Text LI
Hi, Need help on how to count the number of times a Text dimension LI shows up under a List LI. We have tried to use the SUM function as well as LOOKUP function, but they did not work. For Ex) We would want to know how many "Merchant Id's" are under each individual 'Legal Milestone" Below are snap shots of the two line…
-
add child to certain list members
Hi guys, i have a module dimensionned by a list, this module is published in the new ux as a worksheet with an action button that enters data. what im trying to ask is: is there a way to achieve this (pic) ? i have a flat list, parent hierachy = total.
-
SUM with Group Number
Hi I want to sum Orders with Group Number. The point is Group Lineitem is not formatted List, is Number Formatted. 1-Nov2-Nov3-Nov4-Nov5-Nov6-Nov・・・Group123123 Order100200300400500600 Odrer(Sum)500700900500700900 I tried Rankcumulate or Sum Functions, But I can't Solve this.