-
[HELP] Level 3 - Sales Planning Sprint 1 - TAR01 Detailed Sales Target Module | 1.4 & 1.5
Hi Everyone, I've been stuck the last few days working on User Story 1.4 & 1.5 | 5.2 Model Building Specifications. There isn't enough information for me to comprehend what is needed to be done and thus all my numbers aren't correct. I'm positive my other user stories are working as intended based on the examples they…
-
Movingsum function
I am not getting last 2 line of this table .how it is done
-
Sequence of Production Schedule based on Priority and Line capacity
We would like to seek assistance on how we can build a requirement where Anaplan needs to recommend the sequence and volume of products to produce in a line with consideration of line capacity and priority. Example: Data: Line 1 Capacity = 100,000 Products produced in Line 1 Priority Weekly Volume Product A 1 10,000…
-
Statistical Forecasting Discount Factor
Greetings! One of the models in use by my company is the statistical forecasting model, whereby material history comes in through a calculations module and the material is assigned a forecasting method based on the data there. Leadership has requested a change to how the history is weighted that they have referred to as…
-
Finding text substring in a List
Hello All, I have a requirement where my end users are doing some manual text based tagging(excel screenshot below). Within Anaplan, I maintained this mapping as a list with the tagged value as a property. I tried using FIND/FINDITEM of the substring within the Memo TL text line item, but in vain. Can someone help me with…
-
Converting data
Hello everyone, Is there any possibility of converting line item formatted as period (Month) into the TEXT? Thank you
-
Formula/Ratio Summary methods
Hi Colleagues, Master Anaplanners. I've recently bumped in some complex calculations where I had to use different logic for different levels of hierarchy, most I've achieved through Ratio summary method, but there's one I cannot get it work. Hope I can get some ideas or out of the box thinking from you: - NSV/KG is a…
-
How to Pull Amounts from Prior Periods and Place it to a Module Using a Different Time Range
Hello, Good day to you, all. I would like to ask this question that's been bugging me for days now. Situation: 1. I have a module that houses actual data primarily used for uploading a csv file. This does NOT have time dimension as the the period is only a line item. But since the model calendar is from 2018 to 2022, it…
-
Missing line item in the formula below.
The problem I get after I insert the formula is the its tell me formula is invalid because the line items is missing and i attach the instruction of what I was trying to accomplish.
-
Dynamically Selecting Following Year in Time System Module
Hey planners, I'm sure there is a logical way to go about this, but I'm stuck in a mind maze. I'm simply trying to dynamically select the following year in my time system module. Actual period is Jul 22 and the model time is 2020-2024. How can I have a boolean select only the year 2023, yet move to 2024 once the current…
-
Lookup if Code in one Module exists in another Module
I have two staging modules: 1) Account Master, and 2) Account Ledger What I am looking to do is populate accounts from the the account master where the accounts exist in the ledger. I don't want to populate ALL the item in the account ledger since there are items which are no longer used, or that are "helper" items for JD…
-
TR02 Account Details Final Account Sales mismatch check on the build
Hi guys i don't know where did I do wrong its mismatch on the 2nd pic below on the check build anyone give me some tips where did I do wrong thank you
-
Quarterly Lookup
Hi, I'm trying to look up the last day of the Quarter for a LI, and then also find the average of a Quarter. How would I go about doing so? Thank you
-
Flag list member based on whether it's referenced on a property of other list members
Hi, I'm sure I'm having a blond moment. What's the easiest way to achieve the equivalent of this Excel formula/situation (Column F), in Anaplan ? Thanks!
-
How do I move one value to the next month?
I have a calculation currently in the "Usage Base Forecast" line item. I want it so that if a user checks off the "Use Previous Month Final Forecast", it moves the final forecast from last month to next month. For example, if the boolean is checked off for July, it will take the "Usage Final Base Forecast" and move it to…
-
Any alternative for the TEXTLIST() function?
Hi all, The use of the TEXTLIST() is not a best practice. However, as I go through the Anapedia, Planual and forum threads I haven't seen the alternative for that. There are some forum threads that provide ANY, FIRSTNONBLACK, LASTNONBLACK as alternatives for the TEXTLIST[], which is aggregation function. But I need…
-
Display year based on range of numbers
Hello, I have a module that contains a bunch of servers, and for each server there is an asset tag. The asset tags are in sequential order. I was wondering if it was possible to display the year for each server based on a range of the asset tags. For example, for a given sever, I would like it to display FY17 if its asset…
-
Not able to sync the tables (main table and the subsidiary view)
Hello All, I have an issue where in there is table 1 with below structure: List (category list)Line item1 Line item 2DifferenceA11257A2410-6B11020-10B2633Total3238-6 And there is a table 2, which is a Subsidiary view created based on a source module that is used bring the count/ values in table 1. The purpose of table 2 is…
-
Can I add drop down list (with data from a list) to cells that are loaded with data?
Can I add drop down list (with data from a list) to cells that are loaded with data? I've added a validate button, but now I'm trying to create a functionality that allows managers to make changes to data if the loaded data is incorrect. I'm having trouble including both a drop down list and prepopulated data in the same…
-
Users List as a basic Dimension
Hello, I ran to the several issues when I needed to calculate some values on the Top Users level. * Users list itself doesn't have Top Level and there isn't an option to add it. Therefore you can't get Total number for given line item that applies to Users List. I was trying to do some workarounds (creation of Dummy Users…
-
Prevent Import
Hi, I have a scheduled import into a history module with a snapshot of data, every Friday at 2:00am. This all works. However, sometimes we need to take the snapshot manually earlier in the week, and if this has happened i dont' want to allow an import on Friday. As the import is using anaplan connect and runs every Friday…
-
Converting Serial Number to Data Format
Hi, How can i convert serial number to date format in Anaplan? Thanks in advance for helping. Tom
-
Problem with replacing SELECT with LOOKUP
Hi everyone, I am replacing SELECT functions with LOOKUP as a part of model optimization (2.02-14 Avoid using SELECT). I did it lots of times and they worked but I am struggling with couple of them. My approach is that I use mapping module to use LOOKUP instead SELECT. I add list formatted line item and select the list…
-
Invo5 shipping costs
The above image show what has to be done I have attach the data i am getting for shipping cost is wrong I am not able to rectify please help me out what i have done wrong .
-
INV01 Level2
I have attached screenshot ,what booleans I must have checked in INV01 so that my module will be ready for further calaculatons or whatever changes I should made in this module to make it calculation ready.
-
Level 2 Sprint 3 3.3.7.2 Add DCA to INV01 Inventory Ordering
Almost completed the work Just confused regarding my work plz suggest if I am wrong 1. Should I use "Submit Purchase Order Request" line item as formula in AD02 Inventory Ordering for Overrides "Submit Purchase Order - Write? " OR 2. Should I use line item "Submit Purchase Order - Write? " from AD02 Inventory Ordering…
-
Ability to Select Isolated Cells in Quick Sum Bar
When using the quick sum bar functionality (https://help.anaplan.com/anapedia/Content/Modeling/Navigate%20Anaplan/Quick%20Sum%20Bar.html?_ga=2.86794650.366156822.1550101511-1666663741.1546456255), you are currently only able to select "blocks" of cells (a series of cells in adjacent rows/columns). It would be useful to…
-
How to avoid Circular Reference
I am looking for a solution on how to write a formula that takes the value for 1 and Jan 21 and adds that value to the answer to the formula in cell 2 and Jan 21. The formula I have currently is the below. What is in bold is what I need to figure out. IF Financial Projection Time = Financial Projection Time.'1' THEN Sales…
-
Is Something Wrong With my Role List? Level 1
Hi, So while trying to update my Emp02 Employee Expenses module calculations for bonus, car costs, phone costs and medical costs to reference Emp03 Employee Drivers by Role module, I get this error: "Invalid error for 'EMP02 Employee Expenses'.Bonus: Automatic sum of 'EMP03 Employee Drivers by Role'.Bonus % over Role…
-
'List Item' Scope on Formulae
Would it be possible to implement a 'List Item' scope similar to Version Scope against line item formulae within Anaplan. My thinking here would be to allow some list items to be driven by inputs, and other list items to be driven by a formula. This would be a huge enhancement, but in than vein I am unsure as to how…