-
Level 1 Importing data into list
* I am in Level 1, where as an 4.8.2 Activity I have to import data from Employees.csv into * E2 Employees# numbered list. But while importing it is showing Invalid parent. Please help. I am attaching picture
-
New UX - Pages Visibility Layer (by Roles and NewUX Pages)
Hi team, Currently, we have a few global programs in different business areas that unit numerous groups of users from different regions and countries. Mainly we use a global approach for each of county but still need minor customizations for them, so for end-users convenience we have to create customized pages based on the…
-
Time period check box
hi! When I tick a checkbox for a year, I want that month to be displayed in full. I think it's simple, but I can't do it. Please help me.
-
Ability to create Formulas between models
As a workspace admin, i need to build connected planning between models, meaning direct formulas references between models themselves. This is needed as our current only option is to either use import actions which need to be either run manually, or scheduled through cloudworks or would require a substantial amount of…
-
Serial Numbers in Anaplan
Hi All, I have a module with a subset of numbered list applied in its dimension. We want to derive the S.No/ Count of Items in the list in a line item in the module eg: If the list has 3 items A,B,C in the mentioned sequence itself then corresponding to A in the line item built we need 1 then corresponding to B we need 2…
-
Update List Property
Hi, I have been trying to update property in a list from a module with different dimension. Can anyone assist please?
-
ISACTUALVERSION - correct Output
Here's the official documentation on the formula - https://help.anaplan.com/138ee6b0-34a3-4654-b944-f655e6b28ad8-ISACTUALVERSION As per the article, ISACTUALVERSION returns TRUE for Actual Version and FALSE for all other Versions. However, I observed that the actual output is different when you use Time as a Dimension.…
-
Date Formats - Month Name/Text from Date
Hi, Does anyone know of a function that I can use to format a date in a specific manner. Bringing in month names instead of numbers. e.g. From 1/1/2014 I want 'Jan 14' as text In excel I would the text function - TEXT(*date*,"MMM YY") Thanks, Simon
-
Level 1 Activity 9.2.6 add formula to Margin calculation Module- Cost of Sales
Hi I am on learning level 1 activity 9.2.6 of Anaplan. I am struggling to insert the right formula for cost of sales formula as per training module is : Cost of Sales'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Cost * (1 + Unit Cost Growth %) All the other formulas are working well. I also tried to write the…
-
Conditional Formatting rule Inputted by user
Hi Guys, I just want to ask something. Now in the conditional formatting screen we have the range of MIN MID and MAX right as the basis for the color of the cells in Anaplan. Is there a way where the user will be the one to input the threshold (is the term we use in the model) or the MIN MID and MAX. in my example below I…
-
Workspace access
Hi, I am unable to login to workspace and can anyone please assist me on the same. Akshay Mail I'd:- akshayanaplan@gmail.com
-
Best Practise Recommendation
HIya, I am currently pulling various modules out from a large model to provide better user security, I then plan to pull the data from the top level module back into the main business model. Is this something you recommend doing via a monthly import?
-
Time filter for current FY
Hi, I have an issue related to time filters. I have a module dedicated to time filter which I use for my other modules to show the relevant years/months. My fiscal year is from jun-may, and I want a filter showing only the current FY, that is from jun 2021-may 2022. I hence want to have booleans ticked for those months but…
-
List Subset
Does Anaplan treat List Subset as a different List? Because when we changed a module dimension from "Product list" to a subset of "Salable Product list", all the filters got removed.
-
Thank you, Modelers Forum!
Thank you to all our forum members who attended yesterday's session with @Paul and I - we hope you enjoyed it and took away some food for thought. Special thanks also to Stephen Brook from the Product Team for leading the discussion and providing insight on the current and future potential state of Model Management. Watch…
-
Can you pull line items into a modual from USERS list, fore example First Name, Model Role?
I am trying to set up some dynamic access within a model using read / write access drivers within certain moduales. I plan to do this by setting up a modual to set the access at user level using the user list as one of planning keys, but would be good if could pull in the assigned Roles, first and last name as would mean i…
-
Conditional Formatting on Parent Level only
Hi, I've been building a module with a list composed of several children and one parent. The children can be associated with positive or negative numbers (rate of change). As a parent, the amount associated to it is the sum of all its children. I'd like to add conditional format ONLY to the parent to check whether the…
-
New Line Item Text Format Type - SmallText
First, I would like to address that I do not know how the back end of Anaplan is built, so I am unsure as to the possibility or ease of implementation of this idea. The idea is taking a concept from SQL Server. SQL Server has the following data types for storing integer values: bigint, int, smallint, and tinyint. The below…
-
Level 2 Sprint 3 Safety Stock Exception DB
Hi Team, @Misbah @einas.ibrahim I am Struggling with the data not auto refreshed in Safety stock exception DB. eg. If I select FY21 page selector then it is not auto-refreshing the data and even when I refreshed it manually then also I am seeing FY20 data. I have made show selection in my INV02 module for months as in…
-
Summing a line item based on time period in another line item
I'm attempting to come up with a total amount per period. However, the module I'm working with is not dimensioned. I have a month formatted line item called 'Period' and am hoping to sum up the 'Amount (LC)' line items that correspond with each Period entered. For instance, I'd like to see a total sum of the individual…
-
Different Time Scale problem
hi! I want to display the values from a module with a Time Scale of Half Year to a module with a Time Scale of Month. Can i do it? Please help me.
-
Circular References
Hi All, This is a pretty usual issue that I have seen others encounter as well but wanted to check if you have an elegant way of making it work. I am trying to calculate the available inventory at hand on a particular day using the closing stock on the previous day. So Day 1 would pick closing stock of Day 0 and calculate…
-
L2 Certification
How many Exams are there in L2 certification. Is it 3 or 4 and how many attempts are allowed per exam as well as per Questions?
-
Deafult Forecast Errors
i m trying for Default Forecast and also with Round formula..I m confused about the formula. Can somebody help for this ?? I got the Baseline Forecast and Growth Rate%
-
Question in L1 Modelbuilding exam has same Role name as Department name.
Hi, Please can some one help me on how to do this as Department as well as Role name have same name Executive and same code Ex in them. How will data flow in to the module correctly in this case. Roles list data is RoleParentCode ExecutiveAll RolesEX Senior DirectorAll RolesSD DirectorAll RolesD Senior ManagerAll…
-
Anaplan - tracking upload status
Hello, I need to create a module in Anaplan to track the status of data loading. 1. Users are loading data using Excel Add-In. 2. Then, they need to check a checkbox (Boolean) that the data has been loaded Is there any way to know when the user has loaded the data/checked the checkbox? This functionality is need to inform…
-
COLLECT() function issue
Hi Community, Please see attachment for the details of the issue. Any feedback is appreciated Regards,
-
Level 2 Sprint 3.3.5.5 Final Shipping Method and 3.4.3 Country Made in
No matter how hard I try I am not able to the right formula for Final Shipping Method, so far my formula is "IF NOT Override Shipping Method OR ISBLANK(Override Method) THEN Shipping Method... Another query is do I have to give a formula for Country Made In line item...if so can anyone give me a hint?! Thank you in Advance…
-
3.3.5.3
I have configured the hierarchies properly but the parent Hierarchy is not visible in my INV01 Inventory Ordering module
-
Automated email notifications
Hi, we have requirement in our anaplan model that we need to send an notifications before due date to multiple users which belongs to different business segments .