-
Level 2 Sprint 2 Forecast cf formula
I have been struggling with my formulas and I just wanted to check that my Forecast cf formula was correct. It worked the first time which made me nervous. The instructions are: * If Initial Demand Forecast is EQUAL to the Final Forecast, set value of Forecast cf to 0. * If Initial Demand Forecast is NOT EQUAL to the Final…
-
How to check Currency based on Company Code?
Hello, Which formula should I use in order to bring the correct Currency based on the Company Code? I try with FINDITEM and LOOKUP functions, but I guess I'm doing something wrong, as I have errors. Thank you in advance for your help!
-
Current Fiscal Year setting in Time?
In the Time setting of the model, I just updated the current period to Jan FY22. The Current Fiscal Year still shows FY21, and I don't seem to have an option to change it. I'm not sure if it is doing anything? But how do I update it and shall I update it? Is there any risk? Please see attached the time setting screen shot.…
-
REP04 Employee Expense Summary Formulas
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…
-
User access
Hi friends I need to publish a module to the dashboard, there are about 10 line items in the module. One user should only be able to see the first 3 line items where as other user should be able to see last 4 line items and so on. I need a solution for this problem. Thanks in advance.
-
Bulk Copy Action
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…
-
level 3 - 4.6.5 Sale Planning Model: DAT02 module
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…
-
Level 2 trainer led course
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
-
Level 3 Model Building: Schema Design - Part 2
Hi Team, Plz help me with the formula for Define in Active Subset? line item from chapter (4.2) List Subsets - Advanced Topics As I am unable to add subset in to the formula. @jared @Misbah
-
Order list function issue
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…
-
Level1: EMP03 Employee Drivers by Role does not return any data
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.
-
Can't refer to Lists in a new formula editor NMX?
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.
-
Calculating the average of a balance sheet item for quarterly / annual totals
I have a number of balance sheet accounts (e.g. Closing Receivables*) for which I need to calculate the average value. This should be calculated as follows: - Monthly: average between the current month and prior month value - Quarterly Total: average of the last 4 data points - Annual Total: average of the last 13 data…
-
How to Identify Number within text and show number as final result.
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…
-
3.4.4 Activity: Create Stock Exceptions Review
My numbers are coming out larger than the given numbers. Lloyd
-
Dropdown list vs Radio buttons
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…
-
Create DEM03 Demand Forecast Module
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…
-
xlookup
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
-
Version Lock-Data Upload
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…
-
List Management - Column Width
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.
-
Private Equity _ performance fee and carried interest calculations
Hi presently I’m in the process of building a hybrid waterfall calculation model —- where I need to show both portfolio company information as well as Investor level carry calculations. I build modules surrounding investor level carried calculations - should I proceed building out modules to incorporate the positions as…
-
3.3.5.2
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!
-
New Modeling Experience - Nov FY22
Learn about some of the new model building experience features and how to level up your model build using them in this short video. [video]
-
Upcoming Platform Features - Nov FY22
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. [video]
-
3.3.5.3 Check Your Work
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.
-
Level 2 sprint 3 3.3.5 confirmed Po delivery formula
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
-
Level ! Exam activity 4 - importing data into SYS08 showing error in Role column-----Solution plz
-
How can i get back the names into E2 Employee# list the whole connected formats changed...
-
L1 Model Building 8.5.3 Activity: Import Data into Volume Inputs Module
Hi Everyone, Could someone please advise how to map this data in L1 MB activity 8.5.3. Please see the screenshot, I have tried time with Column header and then mapping time values manually in the time tab but it fails to map all values ( 36 values failed) Many thanks in advance.
-
Restrict Date Selection
We have a date field to be selected in a line item which is date formatted....Can we restrict user to select a date beyond certain user defined date field....;,e any date they want to select should not go prior Oct 2021....(which is a user defined field) and its dynamic.
