-
Selecting entire List items at one go
Hi All, I am having a module dimensioned with Time and a List 'New' with items 1,2,3,4. It has one line item named True or not? having boolean format. The requirement is that If boolean is ticked against one list item 1 or 2 or 3 or 4 , then automatically the boolean must be ticked for all remaining list items. Screenshots…
-
Variance
I have a requirement as follows: Module SYS 00: From Version (Version list format) , To Version line item (Version list format). Module 1 : Versions , Cost Center , Line Items . Months In versions (customized list) , I have Actual , Estimate and Variance. Line item Cost , Cost Final In the line item Cost Final, I want to…
-
Help on P&L What-If Optimizer
Hi Everyone, I'm trying to build a Simple Optimizer for P&L where Variables are Volume, Selling Price, Cost Price and Objective is to get a Particular Net Income. I'm getting errors and unable to move forward
-
RE Create Inventory Ordering Saved View and Export
Hi , Please guide me how to filter out parent in rows to make exactly same as export view. Thanks Abhishek
-
How to delete Anaplan Community Account
How can i delete my Anaplan Community account which i deleted by mistake.
-
How to Apply Finditem for Lists loaded with Combination of properties
Hi All Say I have a list A (Numb List) loaded thru combination of properties having item count of 10. Then List B (Numb List) again loaded thru combination of properties having item count of 6 We cannot have code in both the lists. I want to find items in List A which are matched in List B items, so as to delete them. i.e…
-
Change Order and Style of Line Item Subsets
Hello, I am looking for some help. I have a module, call it "Module A", which feeds a Line Items Subset, call it "LIS A". I used the "LIS A" to populate an end state report, call it "Module B". How can I change the order and styles of the LIS A points in Module B? When i make the edits (reordering of lines or changing…
-
Can I use the time stamp of the user from different Time Zones on the Admin dashobard ?
We have a requirement from the end user that they want to track the "start time" and "end time" based on the "Time Zone" they are working from. Can this be done ? If "yes" how can we approach this. Thanks in Advance.
-
Options for Override
Hi I have a module containing values that need to be reviewed and adjusted by an end user. The values are likely to need to be changed and there is often a high possibility that the value to override with is zero. The data is often copied between different dimensions. What options are available for methods to override…
-
why is my formula not returning any values
I have a numbered list in Anaplan (#Job Profile) this list has a Unique Code for each of the members in the list. the list also contains property line items called "Comp Code" and "Comp Location" I have data module that is being populated with Comp Code values and Comp Location values. What I am trying to achieve is to use…
-
L1 Question 6, getting 0s
Hello, I have entered the following formula and I'm getting zeros on the Employee Expense Summary. Any ideas?
-
Get 1st week of the quarter
Hi, How we can get the 1st week of the quarter? Thanks in advance for helping, Tom
-
Using LOOKUP on multiple properties in a Numbered List
Hi - Wondering what is the best/practical process here. I have a Numbered list (#Job Profile) with "comp code" and "comp location" as properties (Attached for reference). I have a module has the Job Profile Code (Job code = comp code) and Connect Comp Location, the data/line item by itself is not unique but the paring…
-
Sprint 2: DEM02 Module Formula
Hey, When creating the DEM02 Volume Growth Rates by Week module, the activity wants you to "Write a formula to pull Volume Growth Rates value (in months) from DEM01 module and convert to weekly value". However, under the Anapedia resource it links to explicitly states that the functions listed can aggregate from Weeks to…
-
How to filter values based on non-source model dimensions
I've got models A, B and C. A is our forecasted IS. B is an IS of confidential acquisitions. B has one additional dimension that A doesn't have - the list of confidential aquisitions. Connected to B is a SYS module that allows our Treasurer to check a Boolean that controls whether a confidential project flows through to…
-
write the following code in Anaplan.
Hello everyone, I have two questions. Firstly, I am attempting to write the following code in Anaplan, I am using a calendar time setting (time scle :week) picture attached. IF Week = 'Week N' (where in my model N=25, representing the 25th week of the year) THEN Flux_Disp = Starting_Stock - Security_Stock - Demand_Global;…
-
Line item Formula
Hello everyone, I require your assistance with a module I have created. Module 1: Forecast per month, taking inputs such as the forecasted quantity and the number of working days in a specific month. The result obtained is the CMJ (quantity consumed per day). I have also developed Module 2: Forecast per week . It takes the…
-
how to convert date to text
Hi there I was wondering how do you convert 2/3/2020 (which is a date format) to 2/3/2020 ( a text format)
-
error Invalid date or timescale identifier
Hi, I have this message "Invalid date or timescale identifier" when I try to import a data file. The date format in the file is : 30/06/2020 for example. Unsuccessfully, I tried to fix whith a "Custom fixed-position pattern" DD/MM/YYYY. Any idea? Thanks a lot :)
-
Where is the data coming from?
There is an error in the data in the spoke so I looked and the the spoke indicates that the mapping came from this module in the Data Hub. However, the data isn't flowing through in the Data Hub but is coming through in the Spoke. Is there anywhere else I can look? I've tried pivoting the view but no data pulls through at…
-
How to retrieve User Email ID from the system list "Users" in a module.
Show ID's of only those users who have either imported the data. Also if some one imports the data in future his/her ID should be shown there.
-
Remove Limit for List Reset Index
Hello Everyone, I saw a new update that user can reset the list index and allows users the discretion to reset their lists at any point on the basis the list is empty. But this "Reset" option is disabled for me. Can anyone suggest when is this "Reset" option is enabled? Many Thanks!
-
Time setting : Calendar
Hello everyone, I have developed a time setting module that utilizes the calendar month, quarter, and year . This module provides me with information about the number of days I work in a given month (picture attached). Now, I would like to determine the number of days I work in a week, taking into account that my week…
-
Import clearing out data even if list item is not mapped but time is mapped?
During a file import or module to module import, is it possible that even though the list item is unmapped or is not present in the file but since the time period matches, the other items are updated regardless of not being mapped?
-
How to calculate across Hierarchy
Hi, I'm having a hard time trying to resolve the following: I have a module "Planning Approvals" that is dimensioned by Brand Another Module "SKU planning" that is dimensioned by SKU. (SKU rolls up to Brand) Within SKU Planning module, I have a Boolean line item "Line Item 3" that compares if Line Item 1 = Line Item 2.…
-
Sum a line item based on all items in a list
Hello, I am attempting the following: I need to sum up a line item's values based on all of the list items used in the module. For example: the module I am building uses a list of adjustments as a dimension (ex: Adjustment % 1, Adjustment % 2, etc.), then there's a line item in the module for the percent amount for each…
-
Find earliest date and latest date in a non time dimensioned list
Hi, I've got a module, dimensioned by a list (numbers), and line item with the dates of various cashflows. This module is not dimensioned by time. How do I find the minimum value i.e. 23/04/08 and max value? Any help is appreciated, Thanks
-
remove double counting of projects
Anaplanners, I have a query on how i can remove double counting of Projects. Case artifacts: T1 Teams, which is a hierarchical list, so for example Team A.1 & Team A.2 rolls up to Team A, like wise Team B.1 rolls up to Team B; all rolling up to total teams. M1 Members: Flat member list. P1 Projects: a Numbered list of…
-
Check the booleand based on the list formated line item
Hey team, i emp dimesion and anothe same list formated line item another is boolean . if selcte the the emp 1 at list formated line itemn then i should check the box
-
Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module
Hi, Can somebody please tell the formula for this line item in this activity? In the Supply Chain model, create a new module: * Module Name: INV03 Distribution Center Summary * Dimensions: P2 Products list, s G3 Location: Distribution Centers? list, Time (month) * Category: Inventory * Functional Area: Inventory * Summary…