Modeling

I am trying to develop calculation formulas for the REP04 Employee Expense Summary, but keep receiving errors and incorrect numbers. I posted each of my attempts with screenshots of formulas and results below and would like guidance in developing the appropriate calculation formula. First Attempt (1A): Created a basic…

Hello all We are refining the functionality for Bulk Copy as an action. We could do with some clarity over how you see this being used, specifically with regard to ALM. Just a couple of initial points 1. We are not changing the existing functionality of the Bulk Copy action on the versions screen 2. We are going to allow…

Save them from needing to find that import in the Actions list and change the name there.

4.6.5 Sale Planning Model: DAT02 module In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters * For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data…

Hi there, I've been stuck on the import into the SYS08 Employee Details Module (Activity 4). When I run the import, I get the error below: I think this is what's preventing me from sourcing the right answer for Question 5, since the mapping on activity 5 works well for me. Here's how I set up the Roles list: and I've added…

Hello everyone, I've created an input module where user can fill automatically some data. I need to create a rule to load the new data entered by the user in a collection module. The collection module should has the same dimension as the input one, but I'm not sure which formula I need to use. I don't want to use a Boolean…

Hi....does anyone know why there are no trainers led course for level 2? I know the course is available in the academy, but I have done the level 1 in a trainer led environment and I found it easier to learn that way. Many thanks

hi Having issues with end users being able to run the order list function. I as workspace admin can use it fine, and if I set my access level to their level, it works. but the end user cannot all actions, modules and list access is granted to the end user as it should be. but they get the below error. I tried removing one…

Use case: As a user, I want to display the current time (e.g. 9/12/2018 5:00AM) in a cell. This should behave similar to the "NOW" function in Excel. Business case: When a user presses a button, we want to display the last time the button was pressed.

Hi Experts, Below formula does not return any data, i tried many different types but it does not work. but the EMP01 employee driver returns the data. 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role, LOOKUP: 'SYS08 Employee Details'.Department] Regards, Kiran.

Looks like with the last change in NMX in a Formula Editor is not any more possible to refer to Lists. So the only way is to type them in. It's very time consuming and error prone. Could you please have a look if it can be changed. 

Hello, I have a List with names only and no codes. The names in the source system are now increasing beyond 60 characters. I want to change the naming convention in order to accommodate the size limitation. I know I will need to add a code in order to change the existing names. However, if I rename List items, will all…

Before I go off to support and see if it's a "problem" just want to make sure that it's not me! Have a saved view that has filters on the page selectors and am then looking to export this view using the tabular multiple column option (there are three dimensions as rows already) but when the export is run I get every…

Hi All, Can Someone help as to how can we Identify number within a Text Formatted Line item and move those numbers to a new line item with number as a format using some formula. E.g. Line item 1: Text Format : VV123BO Line Item 2: Number Format : 123 ( the line item 2 should automatically identify number in Line item 1 and…

My numbers are coming out larger than the given numbers. Lloyd

We have radio buttons for Site selection on the new UX and I am asked to change that to dropdown list. In order to make the line item a dropdown list, I created the line item with the List format (Site). It seems I can't make Site a dimension of this line item. A lot of the filters in the system were set up based on the…

When using the formula: 'DEM02 Volume Growth Rates by Week'.growth%[LOOKUP:'SYS12 SKU Details'.Product] for Growth % I get a mismatch dimension error. I realized I was getting that error because my SYS12 module does not map to the parent, I've looked back at the course in Sprint 1 where this module was supposed to created…

Rachel Goering (@rachel_goering), James Fleming (@JamesFleming), and Belinda Ha, discuss examples of how to be utilize the Management Reporting features of the new modeling experience.

Hi All, How do i do a xlookup in Anaplan? I would like to have a Boolean identifier for the plant column based the locations in the rows. Basically search the Loc 1 in the plant Column and give a true output against the plant for every occurrence. Added module diagram for better understanding. Thanks in Advance

Anaplanners, I have module dimensioned by Line items, region, Employee, Version and time. Its an input module for the end user to update the Employee cost for employees by region and by time and version. I have set a Dynamic Cell Access for read and write of the above module which locks the version based on the admin's…

I constantly run into an issue where the name of list members is longer than what is displayed in a list. There needs to be a way to adjust the column widths when looking at a list. Current options are to export or copy and paste to XLS. Or to search, assuming you know exactly what you are looking for.

Hi, I have an input module with a user dimension, published in a DB where End users can enter the inputs. I want a consolidated module where I can view all the entries/data but without user details or dimension as it has nothing to do with users. I used the User dimension in the input module to avoid overlapping or…

I am getting the following error when entering this formula: IF NOT 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory in Beginning Inventory. Thank you in advanced!

Learn about some of the new model building experience features and how to level up your model build using them in this short video.

Looking for some insight into upcoming features of the Anaplan platform? Check out this clip from our November Anaplan Live! event to learn about some of the anticipated features of the Anaplan platform to launch in the future.

I need help I am getting negative numbers for my beginning inventory and the week 1 comes off as a 0. On top of that the "Override Suggested Order Amount?" Boolean is not allowing me enter anything even though I have allowed the write access. 

Hello, I am on "1.3.12 Create a Process with Multiple Imports" of Level 2 Model Building: Sprint 1. I edited "1. Build Geography Hierarchy" process but can't find the below highlighted Imports: Instead, I can see the below imports where the action name seems to be the path from which I imported the saved views. Are they…

I have used formula for confirmed PO delivery line item IF PO submitted =1 Then OFFSET(PO Submitted ,shipping time weeks ,0)Else 0 but this formula is not giving desired result of offsetting PO submitted in confirmed PO delivery..attached the screen shot for the issue please help me out on this 

I tried to run process 9 - Import data from Hub. The issue is similar although it's failing to import into the Shipping Metrics. No details of failure is provided. I checked for data mapping by trying to import just the shipping metric Not able to successfully import the shipping metric. Can someone point me what's the…