-
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…
-
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.
-
Properties and Subsets Enabled For User List
Quite literally what the title says. I am able to point and click on the different features just like a regular list, or I can apply the User List for specific roles to reduce sparsity. There are advanced methods of data entry, where validation is done up front, preventing bad data from entering the data set, that could…
-
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.
-
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:-…
-
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…
-
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,,, ___________________________________________________________________________________________
-
In the drill down window being able to filter on values for non blank or non than zero
Hi Anaplan, It would be amazing if within the drill down view you were able to filter on a list of values for items that are non blank or non zero. So for example if you're looking at a calculation with a dimension that has 1000 items you can see only the relevant items with non zero or non blank values that contributing…
-
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~
-
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…
-
2.3.10 activity
I need help, I’ve been on this section for a couple of days and can’t seem to figure out why my data is not populating. My formulas are correct but I’m not understanding.
-
Formula to get code of a parent
Hi, What formula can be used to get the code of a parent list inside a flat module? for example in this particular module the parent is a numbered list and I want to bring its code in the 'Code' line item( Text Format). What method can I adopt to achieve the same? Thanks
-
Need Help: Circular Reference Error
Hi Anaplan Community, I have been thinking of ways to pull Prior Year value into Current Year. Previously, I used OFFSET() formular where I would offset -52 weeks. I have created a demo module below to showcase the original formula, the formula that give me circular reference error and the backup formula. Recently, to…
-
SUM & LOOKUP
Hi All, Just wanted to clear some doubts on usage of SUM & LOOKUP at the same time for same line item If I use SUM & LOOKUP both at the same time for the same line item, its giving me correct details as expected However, if, don't want to use SUM & LOOKUP at the same time, then what can be the options - * I tried with…
-
Formulas in lesson 6 not working
@noelle_murphy Hi, can I set up a 1:1 with you? Some of my formulas in lesson 6 aren’t working & it’s hard to move on from that. I also sent you an email. Thank you
-
Hierarchy Summary
Anplanners, I have a Module (XYZ) Dimensioned by GL (Row Headers), Cost Centers L3 as selectors and few Line items to determine the total amount. Aim is to get input at GL level for each Cost Center. I have a summary module (ABC) which is NOT dimensioned by any LISTS and simply has to take the high level total of the above…
-
Ways to identify duplicates for list import other than RANK or ISFIRSTOCCURRENCE?
Just wondering is there a way to find duplicates where the cell count is more than 50 million and I know in Polaris engine it is possible. Any other way to do it in the classic engine ?
-
Select formula
How would you use a select formula to collect totals for For example I want to fill the base opex row with numbers from this module below (totals only) What formula would I use? Thanks
-
Level 1 Model Building Exam - Model Building Activity 6
Hello All, I've used the SUM function to map region and role into 'EMP02 Employee Expenses'. I've been going through my formula and the source modules for quite some time now yet the formulas still yield 0s. Hope someone can help.
-
3.3.5.2 Inventory Ordering Module Formulas Shipping Method & shipping time weeks is not showing up
I am having trouble checking my formulas. My Shipping Method & shipping time weeks is not showing up and I think it is because in the SYS 08 SKU Details the distribution center is not showing up. It is showing up in the list but not in a line item? Why is that happening?
-
Modelling.
.
-
How do I get the characters before a specific character?
Let's say I have column username where the drop down is a list. A username is "JonSmith-81". I'd like the next line item, lets call it alias, to just pull "JonSmith" from this string. The alias line item is formatted as text. What would be the formula to return just "JonSmith" in alias line item? I seem to get an error due…
-
2.4.7.1 Conditional formatting
Hello. I'm stuck on the conditional formatting for the Final Forecast line. I noticed that my formula for the line item forecast cf only results in 0 no 1's, I'm not sure how to fix this as my conditional formatting will not show blue if I don't have any 1's as a result. Formula - IF Initial Demand Forecast = Final…
-
Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas
Can anyone please help me with the formulas for the line items attached in the screenshot ?
-
Additional functionality of multiple non-linear regression analysis
A description of the enhancement required: To move beyond the statistical forecasting model from Anaplan, additional functionality of multiple non-linear regression analysis and ability to derive data set screening with statistical significance p-values, r-squared coefficients, and more advanced modeling as is being…
-
How do I get the characters before a specific character?
Let's say I have column username and a username is "JonSmith-81". What would be the formula to return just "JonSmith"?
-
3.3.5 Shipping Time
I cannot seem to get this formula correct for shipping time in INV01: time in weeks for the default shipping method for each SKU. TRA01 contains shipping time in weeks, shipping method, and P2 Products. SYS07 contains default shipping method and distribution center. SYS08 contains distribution center, SKU by code, and P2…