-
Model Sparsity - Combination of Dimensions
I have a question about reducing sparsity in a model by using numbered lists to combine a series of dimensions. I am using ledger data that has information by supplier and by department over time. If I create a module that is dimensioned by these I end up with a huge amount of sparsity as most suppliers are just used by 1…
-
3.3.5.2 Inventory Ordering Module Formulas
Why do I not see the values for 'beginning inventory' in my model?
-
Create Demand Export Module and Create a Saved View - DEM04
Let me know, if it is right! Is the time scale right?
-
Can't create workflow
Hello, I was wondering what kind of license/right I need to create the workflow, since I cannot see the "create" button appear above. Thanks, Luca
-
Combining list format and text format
Hi. I have tried to combine two items but because one is a list format, and the other one is text format I am not sure how to combine the two for a concatenation. Thanks in advance
-
2.3.8 Activity: Volume Growth Rates
I'm encountering difficulties in accurately mapping dates in the format "20-jan" , "20-feb" to the appropriate time periods within my model . Any tips ? Thanks
-
Modelling Ideas
Hi All, Is it possible it have a view like this in Anaplan? (Q1-Q4- Time range - how to fit in GAP in the same row). Revenue, GM, OPEX, EBIT will be line items and ASI,PMO,PPT will be list. Please give suggestions on how this can be implemented. Thanks in Advance.
-
Mailto for multiple recipients in Outlook
Hi. When I set up a mailto with commas separating the recipients Outlook tells me I need to change the commas to semi colons. When I change the list of recipients in Anaplan to use semi colons as separators no recipients appear in the draft email. Has anyone else experienced this and found a solution. N.B. We have central…
-
Determine the numbering of the week by period (time settings do not include weeks)
Hi team. I really need help with formula to determine the numbering of the week in month according to given start and end date. I have a module with daily rationing coefficients (they add up to 1 per month and may vary from day to day). Also I have module with list of weeks (1 Jan 23 means First Week of Jan in 23, 2 Jan 23…
-
Formula or Function to calculate a trend from historical data
I am currently trying to calculate rate of leave taken of prior periods and compare it against corresponding months across different years. I was wondering if someone knows of a function or formula that works best for this? Rate of leave taken = Accrued liability reversals(taking leave)/ Previous month(FINAL Existing hrs)…
-
Can we pull data from Source to Target module with different dimensions
Hi, In my source module, i have Employee List and Line Items (Name, Date (Date Format), Salary) In Target module, Have Employee List, Time and Line Items What formula should i write to pull salary numbers from source to target module? Thanks, Priyanka
-
Aggregation Formula not working
Hello, I am having a hard time trying to make a formula work in a summary output module: The dimensions are: time, r&d cost voice (list items: reticles, moves, licenses, services, labor, depreciation, general expenses, other) and cost center. What I expect the formula to do is to get the values from the calculation modules…
-
Level 2 Sprint 3.3.5.5 Final Shipping Method
I think the whole system of candy corn crumbles on the change of "shipping method", because the reorder flag is based on the standard shipping method. So when the system says I have to reorder but I choose to override the shipping method with another shipping method that is slower than the standard, i will receive my order…
-
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest valued cell in a given line item?
-
Anaplan Last year values Summary(Formula)
I have two modules A, B. Module A has time ranges of Week, Month, Quarter, Year. Module B has time ranges of Month, Quarter, Year. What would be the best practice to get last year values from module A to Module B and have them reflected for Month, Quarter, Year? (I tried OFFSET, POST, but got error while changing summary…
-
Anaplan error: Line item not recognized
Dear Community, I encountered an issue during the build of some of our projects and would appreciate further clarification if possible. Brief description of the case: I have two modules, A and B, that contain the same line item names "Adjustment" (module1.Adjustment, module2.Adjustment). When I tried using the same formula…
-
UX Table colours
Hello, I am trying to colour only some items from a table that I have put in the UX on a grid card. Any ideas? Idealy should look like this, only 2 iteams in purpule
-
Which is more efficient, TIMESUM( ) or [SELECT:Time.All Periods]
If I'm trying to accumulate all time periods from a source module with time dimension to a target module with no time dimension, which option is more efficient? Should I use TIMESUM with no start or end date, or a hard-coded select clause for all periods?
-
how can we decide the order of data while displaying them in grid in a reporting slide
so if I want to compare line item values for A,B,C,D,E but i select them in order of BCDAE for displaying in grid in the management reporting slide feature of Anaplan. How can that be worked out?
-
Creating QUARTILE function within Anaplan
This is a method of building the Excel “Quartile” function within Anaplan – it requires 11 Line items, requires that the Data dimension has a ‘top level’ value, and uses the RANK function which has an upper limit of 50 million cells. To start, create a module (or use an existing calc module) dimensioned by your base data…
-
How to re-distribute or retain a value that is linked with a product, even product is deleted?
Hi there, I've situation where the Customer wants to keep the Overhead Values associated with a product, even though the product is being deleted from the hierarchy. I think of it as a manual entry for the value to be retained to that it can be re-distributed among the rest of the products or add to the total in the end. I…
-
Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas
Hello everyone, I get an error when I try to add this formula to the Beginning Inventory Line Item. I'm not sure why I get the error. Can someone help me out with this? FORMULA: IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning…
-
Model Builder Level 1
Hi, I am new to Anaplan and have just started the Level 1 Model Builder course. I am in the Activity 7.2.3 section and have been stuck for a few hours now. Need some help to find out what I am doing incorrectly. I have attached a few screenshots Appreciate help from the community. Thanks Jacob
-
Graph time
Hello, I try to show on my UX graph only several weeks, but now, there are all the weeks shown and the graph is not lovely. Any tips?
-
Can any one tell me how to add categories and how categories defined?
Can anyone guide me on where to find the standard Category values for the Module Functional Area and List in Anaplan? Also, is it possible to change these options?
-
Using List Properties
Hi All, Why is it best practice to avoid using list properties? As a central location to hold all the data relevant to that list that does not require the user to update it seems like a perfect option. I am referring to properties such as all items of the hierarchy and permanent mappings that will never change. My question…
-
Formula DCA to lock cell
Hello, I need some help with a DCA. So I have 3 line items weekly dimension : X (number), Y (number manually input) and Z Yes or No. So : If I select No on line Z, then line Y should be 0 (blank) If I select on line Z Yes and if line Y is not 0, then the line Y for that week (cell) should be locked If I select on line Z…
-
Referencing a line item that has formula summary method, not displaying correct number
Hello, In the example image, I am referencing a line item "TV Programming (Final)" in another module using an If statement IF XXXX THEN XXXX.'TV Programming (Final)' ELSE 0 However, it isn't pulling 4,063,964,538 as expected. I know its an issue with the summary method being set to formula because other line items are…
-
Previous list item in formula
Hello, Is there a way to assign a value depending on the previous list item? In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)…
-
Time Dimension & Value not adding correct
I have a model which has the time dimension (in days) and line items which are date formatted. I'm trying to create a chart which correctly replicated the progress of time change but for some reason any value is not mapping to the x axis of the chart. I have attached a picture for better understanding. In the picture you…