Modeling

Ability to Use Copy Down/Copy Across on a Higher-Level Breakback Cell
Currently, when a builder has Breakback turned on for a line item and selects "Select Levels to Show" in a module and only selects higher levels in a hierarchy, copy down/copy across will not work on these summarized Breakback cells (Fig01). I would like the ability to use Copy Down/Copy Across in a module for on these…
Delete From List Using Selections works with respect to Selective Access?
Hi, Just wanted to confirm that does delete from list using selection works with respect to Selective Access? If the end user has full access of the model and not the admin access. If he runs the action to delete items from a list for which criteria is set to delete all the items possibly of those as well to which he does…
Ability to Export Adhoc from NUX
Unlike Classic, New UX doesn't have the option of allowing users to export the module/view from the dashboard directly without the pre defined actions. Idea is to provide the option to the end users so that they can export the data without running any pre defined export actions.
Delete data from Numbered List No parents
I created a module and process to delete all the data from Numbered list. it works fine to delete the data however there are some data (no parents, just code) which I am not sure how those got into the list are still there(I believe because of the mapping eror). Also, on the delete module, these data dont show up but those…
How to Truncate the combination of string and numerical?
In a module, a line item is list formatted and the data displayed is in the form "String1:String2 Numerical code". How to truncate the data and display the string1 only in the same line item? Example: "ABCD:efgh 12345" (say) is displayed in the list formatted line item. Then, how to display only ABCD in the same line item?
What are these fiunctions for?: HALFYEARVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE
Can anyone tell me what these functions are for? I have read Anapedia but still having a hard time understanding what they do. MONTHVALUE HALFYEARVALUE QUARTERVALUE WEEKVALUE YEARVALUE In the sample below, I guess that "each weekly sales" are compared to "average weekly sales." And it turns out to be "True" if a weekly…
level 1 exam activity 2
Question: In the Level 1 model, update the REV02 Volume Inputs Module to include a formula to pull data from the DATA02 SKU Volumes module Not getting what exactly i have to do in the attachment shared a screenshot of error
L2 Sprint 1 1.3.7.4 Create s G3 Location: Distribution Center? List Subset
Hi All, I created this subset. Should I add this as subset for G3 location list Please advise Thanks, Balarama Krishna
Totals (across a list) without a parent member
I have a module that is dimensionalized by row ID (#1-#n), no parent member for that list. It is an input template to model new expenses. What I am aiming to do is to have another line item (could be in a different module if needed) that will look to see if any of the rows have data. Essentially each row has line items…
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.

Modeling

Discussion List