-
Open a Module in "Line Items" tab by selecting a line item (not just a module)
When I can't remember where I saw a particular line item, I go to Settings ---> Modules ---> Line Items and search for it. When I find it, it would be very natural to just click "Open" in the header. However Anaplan only allows this open button to work if you have the MODULE name it belongs to selected. So I have to scroll…
-
ABS formula
Hi, anyone who can help on formula "ABS"? I need to get the absolute value of the line item, but Anaplan seems to round off the item. Any notes on this? Thank you. Below is the screenshot for sample:
-
IMPORT ERROR (MODEL TO MODEL)
Hi all, Anyone encountered this error? We cannot import from one model to another because this error occurs every time. Kindly see below:
-
Process builder in anaplan
Hi, Can anyone give brief about Process builder and its task in anaplan. Thanks, Keerthi Malathkar
-
How to get the previous period of current period
Hi, Can I please get some reference how to get previous period of current period. PERIOD(CURRENTPERIODSTART()) gives me the current period I,e Jul 17 but I need Jun 17. Previous(period(currentperiodstart()) which is not working.
-
How to add cell values for previous 8 months data only
I have an line item 'Amount' with data values. second line item(months applicable) which is boolean checked for only 8 previous month of current month. I want to add the values of these Boolean checked months only to be summed. Can I please get some guidance here please? Regards Asha
-
Can we create alias names in anaplan?
Can we create alias name for time,versions dimensions in Anaplan?
-
Hierarchy change in planning years
How to save the data of the previous years when we want to change the list items hierarchy in planning years? Other than creating a copy of the model, is there any solution??
-
Formula for the Hierarchy
Formula for the Hierarchy
-
Ability to Merge and / or Replace a dashboard with another dashboard
I would like to be able to replace a dashboard with another dashboard and have Anaplan automatically make all the changes needed to make the replacement be and act as though it was the original the whole time i.e. do all the renaming, change all actions, filters, permission etc. WHY When trying to prevent new features on…
-
Poisson function
My customer needs to calculate the POISSON cumulative results to find out the lambda value that goes above a probability treshold. In a maintenance use case, this is useful for him to statistically determine given a target service level and the past average of incidents how many incidents should occur in the future, and…
-
Customize Model Filters
Consider allowing customers to customize the filter categories. App, Geography, Planning Cycle, Environment, and Business Function do not fit our use cases or model categories.
-
Default Home Page to list view
We would like the ability to default the tiles screen to the list view for all of our users. This view is a lot more user-friendly than the tile view, we have had an abundance of requests for model access when the users do not realize that they just need to scroll to the right to see additional pages of tiles.
-
Custom Format for Lists
Currently all list items default to text. It would be helpful to add them as dates, numbers, etc.
-
NULL Number Format
Null option for number format. Currently when a number in undefined, it will populate the module as a 0 instead of a blank. A work around is required to convert all of the numbers into text, and then make undefined numbers "N/A". The ROUND(TEXT()) function also causes a large number of unnecessary decimals.
-
Default Dropdown Selection
Ability to set a default selection in a list dropdown (similar to how you can in tables and graphs). Allow different default selections on different dashboards.
-
Dynamic synchronization based on list-formatted line item
Dynamically synchronize published tables based on a list-formatted line item page selector. This would save space since we wouldn't have to dimensionalize the model but could use a list-formatted line item.
-
Keep Dashboard Tables Anchored
When making inputs to large tables, the dashboard will scroll back to the top after making an entry. The ability to have the dashboard stay anchored while entering information would save time for users. We are having to use the maximize feature for each table to input data.
-
Mapping on Codes
Allow for mapping on codes in a list that is not numbered.
-
Maintain Flat File Mapping in Copied Models & Model Mappings
When we move models from workspace to workspace, the Anaplan model to model connections remain intact, but all flat files need to be reuploaded and mapped. This causes a large amount of work per model that we move. Adding this feature would make the workspace governance process run much more smoothly.
-
Automatic Sum in Drilldown View
Ability to select multiple cells in a drill down window and see the sum on the back end, as you can on a dashboard.
-
Boolean Format Options
When boolean is selected as a line item format, there should be an option to have single or multiple selections allowed. Currently, the default is to allow multiple selections. For instance, for single-selection, once one line item has been checked, all of the other line items have a greyed out checkbox that cannot be…
-
Sorting Users in Anaplan
Hi Guys Does anyone know a way to sort users in anaplan . I am talking about the User setup / Access Area . I don't want to delete users and re-add sorted lists as it will generate email notifications to users . Cheers
-
Referencing Model Calendar in Formula
Hi all, I am trying to see if there is a way to reference the model calendar in a formula. I want to return the fiscal year that the week is in. e.g Week 1 FY19 Result would be FY19 The intention is to use this to lookup other data, E.g IF Fiscal year = FYxx then... I have a Timing - Calendar Module (screenshot below) if…
-
How to read only 8 previous months data of current month.
Hi, I have created a master time dimension setting module where my current month(Boolean line item) is selected as June 18. I want all the 8 previous months value to be read by a second line item from an input module(second module having data for all period) Amount(line item) should have the values of only 8 previous month…
-
Getting data by line item into a dimension and generalising a complex formula
I want to calculate some values in my "Forecast" using a formula that is almost the same for each value. The only difference is that each row in the "Forecast" module gets an initial seed value from a different line item in the "Base Data" module. The formula I want to use is actually a lot more complicated than shown in…
-
Using different versions in formula
Hi, I'm trying to create a formula that has 2 different views of forecasts. My current and my previous. Current is pulling in fine. Struggling to create a formula that says Fcst V2 = Previous months Forecast. So if Current forecast is p4. I want my FCST V2 to equal my p3 Current forecast.
-
How to add a header name in module grid view
Hi Experts, I want to know how to add a header name in module grid view. As shown in the red circle in the picture. Or, I want to export this spreadsheet, so header name only in export is also welcomed. thanks in advance. Regards, Tsuyoshi
-
If statement not reading periods prior to forecast start
Hi All, I was wondering if someone could help with below. if statement not reading dates prior to forecast start period. Forecast start period is Mar -19 Below should return 0 rather than Mar -19, why is the if statement not reading the first part of the statement? What do I need to change to get it to work? IF…
-
Right-Click on an applied filter ---> take me to the module
When Opening a filter, It would be really helpful if I saw a filter I wanted to dig further into and be able to right-click and open the module it's coming from. Currently a user has to back out of the filter view, and go there manually. When there are a few filters I have to screenshot this view temporarily because I…