-
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 ?
-
Does the "Anaplan Formulas & Function" app still works?
Hello, Does the "Anaplan Formulas & Function" app still works? When clicking on "Download this app" I'm directed to a page "HTTP Status 400 - bad request". Thanks, Evrard
-
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…
-
Formula Help
Hi Community , Can anyone help me describe how to use RANKCUMULATE function with an example , I understand the function syntax and all but I want to understand a use case of where this function can be used. Thank you!
-
3.3.6 Changing OFFSET to LAG
Hi all, Having some issues changing the OFFSET function to LAG. Using the following formula; LAG(PO Submitted, Final Shipping Time Weeks, 0) My Final Shipping time in weeks is 1 for the PO submitted column, the lag I am seeing is however 2; The only way I can get the LAG to show up correctly is by checking multiple…
-
Configuring Write Access Driver by Drop-down
Hello, I am trying to configure the write access driver of an item to build something as follows: If drop-down item is selected, then the write access to a column is revoked. Else, you have write access. Can a write-access driver be configured to dynamically change once a drop-down item is selected? All the examples that I…
-
3.3.5.2
Can anyone guide me as where have I gone wrong in this activity
-
Add MEDIAN Function to Anaplan
As we expand our use cases within our org, we are faced with more and more times that we need to calculate a Median within a data set (ex. Revenue, Median Deal Value, Median Salary, etc.). There is a quite elaborate workaround that is posted on the community, which has been a lifesaver, but it takes up to 13 line items to…
-
Christmas Brain Freeze or Summing from a module when you don't have time as a dimension
Hi, I have a module (SER) with simple data for a PO, value and a year period by customer In an invoice module (that does not have time as a dimension) i want to see the total value for that customer for the year. The invoice items has a Year based on its posting date. SER.Value[SUM: SER.Customer] This gives me the total,…
-
Product Summary Method
It would be useful to have the option of Product as a summary method. For example, if you have a list of % discounts that all apply to one sales order then they need to be multiplied together in order to give the total discount.