-
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…
-
Replenishment modeling with circular reference
Dear Anaplan Community, I am facing a circular reference issue modeling replenishment calculation. For this specific client, their trigger condition to place an order is to evaluate below condition: If I do not place an order today, will my projected end on hand (EOH) on this Item's ETA date fall below this item's safety…
-
Revision tags with multiple builders
My client is asking what is the best way to allow multiple model builders in Anaplan independently? In the current system there is no way to isolate what changes should be moved to other environments, i.e., revision tags are cumulative. How do you all handle this?
-
Summary Method for Lookup function
Hi, What is the best workaround when using the Lookup Function and you need a Formula Summary Method? Currently, Anaplan does not allow this and for some cases, especially using % accounts, it is best to use the Formula aggregation in order to get the right math at top level hierarchies and Time Summaries (i.e, All…
-
Formula Summary for reporting
Have to run a variance reporting for 3 Line items. In the source, the line items have dimensions and Time(Quarter). The variance Reporting module is run by the same dimensions, the source line items act as a dimension(by line-item subset) and looksup the Year selection by the user. The challenge is that one line item has…