-
Help on circular reference
Hello, During my training, I had to build the Inventory ordering module for the supply chain model (level 2). After building it following the instruction, I'd like to test new formulas to determine the Suggested Order Amount for the Month. I'd liked it to be equal to the Forecast demand + Safety stock target - beginning…
-
How to create SYS: Modules, Filter: Period
Hi, I am trying to create SYS: Module and Filter: Period module. Can any one help me in this. Thanks, Maithri.
-
A list item value should be equal to the sum of values of other list items.
Hi friends, I am having a issue related to list items. As shown below, I have a list with items a, b, c, d. I have used this list as a dimension in a module which has value(number formatted) line item. I also have other list with items a, b, c, d, e, f, g. Now, this list is used as a dimension in other module which also…
-
Many to Many Dimensions Rollup
Given: End user can input in the following 9 columns as a dropdown(List Format) in the Input Free Form. Free Form is a module having a Numbered List applied which is having these Line Items as a List Format so that users can choose from the dropdown. Following is the count of List Members in the lowest level.…
-
Formula to add line item from Monthly set up to QTY
Hi Community, I would like to ask if this is possible. There are 3 modules done but 1 module is set to monthly and the other is set to quarterly. See below for the illustration: I had to create an illustration since I cannot provide screenshot from the model due to confidentiality. This is the revenue module. And then they…
-
TAR01 Detailed Sales Target Level 3 Model Building
Hi, I have a question on the LI "Initial Country Sales Targets" in Module TAR01 Detailed Sales Target. For this line item I'm assuming that we are pulling from the TAR01 Sales Targets where the initial country sales targets are calculated. Would I then use my SYS03 Module to SUM by Country and Product? Below is a screen…
-
Sorting and Filtering of the list based on page selector.
Hi Team, I have a module with Location as a dimension and line items Sales, Profit, Expenses, Opex and Margin. I want to create a Dashboard or Dynamic Report where these line item will be Page Selectors and the locations will be published based on the selection , sequenced and filtered with TOP 5 values. For Example :…
-
L1 Model Building - Actual and Forecast settings and difference
Hi, I have just started L1 MB course and unable to understand time settings. Could someone please explain why Actual period is FY2019 and not FY2020 when we have set the current year to FY2020 in main time settings . Also why forecast period includes FY2020 ? Please see these below SH. Many Thanks. J Hamid
-
Retrieve Current User
Hello, I can use item(user list) to get current user, i.e. the user who login current system, it requires to use user list as dimension. Now I have a module which is not dimensioned user list, is it possible to retrieve current user directly without adding user list as dimension? Thanks in advance.
-
Round Robin / All possible Pairs from List
Good afternoon (and sorry if this is a real beginner's question), I have a quick question regarding Anaplan's functionality. I was wondering whether it is possible to extract all possible pairings from a list (e.g. across the dimension of playing rounds), so that each list item is paired with another exactly once,…
-
1 GB Workspace - 90-Days Anaplan Access Program
Hi, I was granted access to Anaplan Learning through the 90-Days Access program. I am unclear on how to get access to the 1 GB interactive workspace that is included in this program. Do I need to send in a separate request for the Workspace even though I have access to this program? I have sent emails to the TalentBuilder…
-
L3 Percentage calculation Not Matching
L3 Sprint 1 - User Story 5 My Percentage is not matching This is my Ratio. Let me know where I'm going wrong.
-
Time mapping issue
My Mapping looks like this What mappings needs to be done in the Time i can select the option for DD-MMM Please guide Regards, Srini
-
Input Percentages in Accordance to a list
Hi, I need help on knowing what are best practices for inputting percentages that are assigned to each item of my list. I do not know if I should do this as a Module, or should I just create a List Property that holds the percentages? Thank you
-
New Modeling Experience access bug
I've been using the new modeling experience mode as a workspace administrator and i've been having the bug where I can't access the modules/lists/dashboards I have open, and a notice saying that I don't have access to those resources. Has anyone else experienced this? I can normally bypass the bug by opening the last tab i…
-
Level 2: Conclusion INV05 Shipping Export
First of all, I greatly appreciate this community and the help you provide. I have been wracking my brain, searching, and unable to find an answer. Perhaps I'm over thinking this? I was able to get the sum of the Final Shipping Price in with no problem. Where I'm stuck is the Code. I read that I "will want to import G3…
-
Formula that will pull from another LI every other Thursday
Hi, Need help on how to set up a formula for a LI that will pull from another LI every other Thursday? Thank you
-
Year values to months
Anaplanners, For an input screen, I want to enable users to input at a yearly level and then I want that same value to flow to every month pertaining to that year automatically. This is to make life easier for the end user to not input data at a monthly level, rather do one input at the year. Example. Value for FY 20:-…
-
RE 'Country Made In' Line item of SYS08 module
Hi , Please help me to understand if list format for 'country made In' line item would be G2 country list or subset list of Distribution list for the 3.4.3 Activity: Create Country Summary Module. Thanks Abhishek
-
A Way To Create A Custom Time Aggregate Filter and Selector
Custom Time Aggregate Filter and Selector by @JohnB & @ShaneenW We present our approach to creating a custom time aggregate filter and selector. We look forward to learning a more efficient approach to creating a time aggregate filter/selector or tips/tricks to shorten the approach below. 1. Create a flat…
-
2.4.7.1 Create Demand Forecast Grid UX saved view Not formatting
I entered and cross checked my data inputs and formulas. The conditional formatting is not functioning. Please help
-
Calculation of modules & Size....
Hi Everyone, Can anyone help me to understand, how we are calculating the module size in GB format? If I want to see the actual size of my modules in GB then, do i need to enable any option in Anaplan. Regards,,, ___________________________________________________________________________________________
-
Stuck inside a subsidiary view
Hi All, On a number of occasions when reviewing subsidiary views I have found that I am not able to return to the default view. Despite, selecting 'default view' from the tool bar I am forwarded back into the blueprint. The only remedy I have found that gets me back to the default view when this occurs is to close the…
-
How to get the Index of a Numbered List Item ?
Hi guys as the subject, I want to get the Index of a Numbered List Item, what attribute/property should I use? the Propeties I've tried: (Item )Index (Item )ID (Item )Number (Item )suffix by the way, what is the data type of the index? Thank you~
-
2.4.11 Activity: Create Roles and Test as End Users
Hello! Would love some guidance here. Roles were already created And for Product Family Manager I have Write access for DEM01 but not sure how to navigate the rest.
-
CUMULATE circular reference
Hello, There are similar posts on this topic, but none of the solutions seem to work. I am trying to create an inventory calculation that allows the user to delay/push production to subsequent periods. Then, the total production that has been pushed will be produced at one time. CUMULATE is currently used to aggregate the…
-
Summing of list items to another list item in the same list
Hi There is a requirement that we need to sum list items total to a specific list item in the same list based on some selections User selects Yes/no one line item(drop down) and Revenue method on another line item(drop down) Lis items which are having Yes should be summed to the % revenue method list item attached…
-
Different switchover dates for financial statements in same model
Hello, I am brand new to Anaplan and am building a long range plan that has P&L, BS, CF. Our actual version in AP for the P&L is an import from our accounting software that is actuals + forecast = total FY year. For example, our FY year ends 6/30 so if I am in Dec, i will load a file that is 6 months actuals and 6 months…
-
display name not referencing module line item
Hi: Any help would be appreciable. I have numbered list and has property display name. It has formula to reference from one of the module. However it is not displaying anything on that display name property section even after I set display name property. Is there anything I am missing? Thank you
-
How to connect a long list of vendors with multiple other lists
Does anyone have experience creating a module with a long list of vendors (4000+) by multiple dimensions (market, department, legal entity, business unit) without breaking their module? Currently we are only able to show by one dimension but we really need it by all four, would greatly appreciate any insights on how to…