-
How to use “LOOKUP” function in Anaplan: Explanation through an example
Hello Anaplan Community, During my Level-I and Level-II trainings I thought that it would be useful if an explanation with an detailed simulation for use of LOOKUP and SUM functions. There for I prepared a detailed explanation for each functions. Below you can find the explanation with an detailed simulation for use of…
-
Dependent list: The value entered is not valid
We built 2 dropdown selection fields in NUX. In this case, we have Division Selection (parent) and Business Unit Selection (child) in the page which gives users 2 levels of flexibility. Users are allowed to select one of the divisions from Division Selection and obtain the business units under the selected division when…
-
Sample Reporting
Good Day All I m looking for a sample report template on the assessment of incorporating two models into one ( like workspace optimization, impacts, and advantage ). Can anyone help to share the same? Thanks in advance.
-
Possibility to turn off sorting a grid, double-click the column header.
With the new Anaplan release users in UX can sort a grid using double-click the column header. That feature might appear to be a problem because users can double-click the column by mistake (especially if the columns are used for synchronization). We definetly need the ability to control this feature. It can be a selection…
-
TEXTLIST summary for line items with format set to Text
As Model Builder, I want to have additional choice - TEXTLIST - when selecting summary for line items formatted as Text. When TEXTLIST is selected, summary should join/concatenate lower level data. Preferably, joining should be done using separator defined by user (as different appilcations may need comma, colon, dot,…
-
Total number of Archived models in Workspace
Hi team, Is there any limit of archived models that can exists in the workspace? Any links/articles will be appreciated..!! Thank you, Shraddha
-
Count line items
Hi, I am looking for a way to count the number of TRUE items for a Boolean formatted line item. As per above image, since 3 of the Booleans are selected, I need a mechanism where I can get 3 as the output (it could be in different module as well)
-
Using Users Dimensioned Line Item in a Formula With No Users Dimension
Hello, I have L1 and L2 lists, and recently I added a new flat list as A, and A is actually acting like parent of L1 that determines the groups L1 list members belong to. Since I do not want to mess the existing hierarchy and model functionalities, I prefered adding A as a flat list. In an L2 system module, I have an L2…
-
Filter with Sync Selections
Hi All, Just looking for ideas on using filters and sync selections together on different axes... I want to filter the Markets (shown in Columns), and use Sync Selections on Products (shown rows) to only show the products under a selected Product Category. *See screenshots* Currently the filter isn't working because you…
-
Employee department Change
I have an Employee details module which includes ( Code, Name, Start date, Leave date, Salary, etc.). There is one more module where the monthly employee salary is shown and we get the salary detail until the employee is employed. I have made a process where the employee has changed departments on a certain date. For…
-
Dates in Timesum
Timesum formula currently works with time periods. When the granularity of the data is Days, the formula cannot return anything (although it does not generate an error). The idea here is to enable Timesum to also work with Dates so that we can apply this formula to more granular use cases.
-
Nested Axis Sorting
Hi I have a nested axis that I would like to sort. This is something that is not supported - but does anyone know of a workaround for this? I was hoping that if I hid the subtotal on each line item it would allow the sort, but it does not. If there is no workaround, I hope this is something that can be considered for the…
-
Level 2 Sprint 3: 3.3.5.2 Shipping Methods Formula
In the Inventory Ordering Module, I'm trying to use the below formula for Shipping Method:- 'SYS07 Distribution Center Details'.Default Shipping(LOOKUP : 'SYS08 SKU Details'.Supplied By)But I'm getting an "Invalid Formula" error.'SYS07 Distribution Center Details'.Default Shipping is list formatted to "Shipping…
-
The importance of a Runbook: The evolution of model documentation
Author: Marc Weinzimmer, Certified Master Anaplanner and Senior Manager at Lionpoint Group. We've all been in this situation before. You find yourself in a conference room, and someone asks, "What documentation do we have on our monthly process in Anaplan?" Panic starts to set in as the room falls silent. The truth is,…
-
removing lists not required
hi If as list is not referenced by its settings can the list safely be deleted? ie not referenced in anything below
-
XIRR Formula
Hi, I am trying to use the IRR function in Anaplan. I have a dummy list of cashflows, with the following dates and net cashflows. In excel, I would just use the XIRR formula on cashflow date and net cashflow, but in Anaplan, what is the best way to add the redemption value in the current period and perform the XIRR…
-
Module view: Column Wrap
I would like to have an option in Module view to set width of columns so that the name of line item and data is visible. Similar to excel functionality where you can click on "Wrap Text" and it sets the width automatically rather than change it manually.
-
How do I take MAX value of weeks and use it as my monthly value?
To illustrate Module A in Model #1 has a weekly time dimension My goal is to take the highest weekly MTA number of a given month and bring it to a new Model that's dimensioned by months and use the MAX weekly value from Model #1 as my new monthly value in Model #2 MTA's time summary in model #1 is set to Max When I brought…
-
User Subsets
As a model Admin controlling subsets of Users would help with reporting and certain modules that are only required by a certain number of users. Currently the users list must be used as is so if you have a large user base, that could create very large modules. If there are specific reports that only certain users should be…
-
Add ability to import Format, Summary, Applies To as part of module blue print import
Currently, you can only import line item name, line item code and parent in module blue print mode as per screenshot below: The request is to expand it to include the ability to import Format, Applies To and Summary. And if not too complex, the Formula as well. I'm finding during various project engagements that there are…
-
13.6.4 Activity: Add Line Chart to Margin Summary Page
Hello, I'm in the middle of my L1 model building training and I've ran into an issue that I cannot seem to fix. According to the solution, my "Forecast Volume by Month" line chart should look like this: However, mine looks like this: I know this is because mine has FY totals included in the midst of the module view. When I…
-
Disable formulas in Version
I would like to see the possibility to disable formulas for an entire Version. This would enable to save a bulk copy of latest forecast without regards to change in logic. Currently this is managed by saving a copy of the entire model but that makes it hard to compare.
-
Model size has been rejected after adding new line item: How do I solve?
I'm not able to add a new line item to our DEV model because of the following error: The model size is actually 20gb. I don't think the size is an issue. Is there another reason for this error? and how do I fix it?
-
Set conditional formatting by formula
Description of the enhancement required: Improve conditional formatting by allowing formulas. An example of the enhancement: Have it function similar to excel where formulas can be used to test for conditions. How would it help their business process: Extra line items must be used to check for a condition, if conditional…
-
Mail Attachment
Anaplanners, Is there a solution or a way to have mailto generated out of Anaplan to also include an attachment. I did try my luck online but couldnt get a solution. Have any of you faced this requirement and how was it resolved if we cant automatically attach. Thanks
-
Dependent dropdown
I want to create dependant dropdown for Accounts (Dependent on Country and Segment) to complete the user story 2.5 Level 3. However I am able to select only one either country or segment. How can I create account dependency on both? Thanks -Pooja
-
Populating list subset based on a Boolean from a specific version of a module
All, I need to update my hierarchical list subset from a module with versions. I have a module dimensioned with my list and a saved view in forecast version with a Boolean formatted line item (already populated and true for several items) based on which I need to update my list subset using action but I couldn't find my…
-
2.3.9.3 Update Historic Volumes for Baseline Forecast
I am having trouble adding a line item as my model has exceeded size. Here is what I am seeing on my screen.
-
L2S3 INV01 Shipping Costs
Hi community members, can someone please take a look at my formula for 3 3 5 6 Update Inventory Ordering to Calculate Shipping Costs - Shipping costs line item Here's the formula hint provided in the course: Formula Hints: Shipping Costs: * In the TRA01 Shipping Metrics by Week module, the Shipping Costs are priced per…
-
Function to return the number of leaf items in a standard or numbered list.
I think it would be very useful to have a function to return the number of leaf items present in a standard or numbered list. Example: QUANTITY(x) Where 'x' is the name of the list, also selectable from 'General Lists'. Reasoning: This would serve as a cleaner way to get the number of items in a list, instead of doing…