-
Add a Parent to a Line Item Subset
It would be nice to be able to add a Parent list/hierarchy to a Line Item Subset.
-
Show full numeric value in Drill Down and hover over
When I drill down into a calculated numeric value, I want to see the full numeric value of the source cells that play into the calculation. Right now, I only see the rounded value based on the Number format that I have set for the cell. It would also be helpful to, as a user in a dashboard, hover over a value that has been…
-
Collect Function doesn't work
Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…
-
RANK with Selective Access
I'm trying to build a module that displays only the top ten cost centers based on a variance line item that I've got calculating. I'd gotten it to work with a RANK formula and then a boolean line item, but then when I started trying it with selective access set up on the cost center, it broke and I only see a few of what…
-
Collect Function doesn't work
Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…
-
How can you capture the last update date in a list?
Hi I have a requitmemtn where the data is maintained in a List and when the user updates the data (edit/create),then we should capture the system date in a column in the list. This is to know when the data was last updated. Appreciate any pointer on how this can be acheived . Thanks Regards rabakaran
-
Collect Function doesn't work
Hi, guys! Collect function doesn't seem to work on the model that I am currently building. I have created line item subset using one of the modules I have created. I used this line item subset in my current module which has the same dimensions as with the source module where the subset comes from. I can't figure out why is…
-
TEXT function to have the option to convert the displayed format
Description of the enhancement: Currently using the TEXT function it will convert the underlying number. For example, if you have: Line Item 1: Number format, set it to 5 decimals - value: 0.0000005 Line Item 2: Text format, Formula: TEXT(Line Item 1) Result: 5-E07 Desired Result (in TEXT FORMAT): 0.0000005
-
How can you "Paste Link" in Anaplan
Could not manage to “paste link” the TO PAY (SAR) column (manually inserted in module X) from X module to Y module. The look up unique identification is the Transaction No. OR Document Number. Can you help? Module X PAGE: Bank Element List Vendor NameVendor CodeVendor CategoryDocument NumberAmountTO PAY (SAR)OUTSTANDING…
-
Use line Item of a Module as Filters on a Dashboard
Hi , I want to use a combinaision of line items in a module I published as a Dashboard as filters for that Dashboard. This without creating a Button for refreshing the result in the dashboard but to have it updated automatically according to the selection of those 2 lines Items. Is this possible and how ? Thank you in…
-
Date comparison
Hi all, I've got a line item where I import date from AWS everyday. I also have a list called Split Week where I have two 'Date' formatted properties called Start of Week and End of week. Is there any way I can check if the Date of import lies within the 2 properties? Thanks in advance. Prateek
-
How should I debug to see what's happening exactly in my formulas?
Hello, One of my client is operating some models which drives a connect Supply Chain Network, and they need a stepwise debug execution so as to see what's happening exactly in the formulas. Due to the fact that most of formulas are bid over complicated, step by step debug execution would be nessary. Any ideas and comments…
-
Calculating the IRR for a subset of cashflow
Is it possible to use the IRR function to calculate only a subset of the cashflow? For example, in Jul 18 I'm looking to calculate the IRR of the cashflow from the beginning to Jul 18 and then on Aug 18 it will be from the beginning to Aug 18. In excel you can simply have the formula as IRR($H2:I2) and apply that across…
-
Need help in Formula
Hi, guys! I'm doing a logical formula in my module that says if a Unit (Line Item) is classified as Current (List: Sales Type) then it will perform a certain calculation otherwise if it is Non Current (List: Sales Type) then it will display zero. Can you please recommend me a formula for this? Note: I have uploaded the…
-
TEXTLIST as aggregation function, but only display unique
Hello, Is there a way to get the TEXTLIST function, when used in the aggregation format, to only display unique entries? I have the formula working in my model, but it is displaying every entry under the parent, rather than unique entries. I know that the normal TEXTLIST function has a "UNIQUE" option. Best, Matthew
-
Summary of Selected Cells Displays on Dashboard
Description: When selecting several cells in a module within a dashboard, we would like to see the summary (and perhaps average and count) of the selected cells displayed as well. This is similar to the customized status bar in Excel that shows the Average, Sum, and Count of selected cells.
-
Mailto function multiple line body
in regard to the mailto anapedia, how to have the body of the email to have multiple lines? i.e. how to make %0D%0A work in to the mailto formula?
-
Dynamic Versions in Anaplan
Hi Team, My model has 4 versions: Actual Version: Monthly Input Forecast Version: Once yearly Input Q2 forecast Adjustment: Q3 Forecast Adjustment: Let's suppose we have forecasted for whoel year and users are done with Actuals input of Jan,Feb,Mar,Now the Higher management wants to adjust there forecast for Q2 in which Q2…
-
Include slicer functionality similar to excel - i.e. save filters in a button
Description of the enhancement required: Enabling slicer facility in Anaplan tool like the one in Excel https://support.office.com/en-gb/article/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d How would it help your business process: Customer would need this facility of Slicer enhancement due to multiple…
-
Custom time period format
Description of the enhancement required: Include a way to format weekly dates by Start/date - end/date such as in excel. A story for why they want the enhancement: Currently we have a gantt chart view in Excel which shows run dates on the columns with the activity detail in the middle of the grid. It is easier for us…
-
Add new function AllPeriodsValue
Description of the enhancement required: Add new function AllPeriodsValue An example of the enhancement: The AllPeriodsValue function would work like YEARVALUE, but utilizing periods rather than year. It would have a parameter to choose whether a Brought Forward value should be included in the result. How would it help…
-
List cell "Contains" Typeahead
Description of enhancement: List cell input typeahead to work by "contains" typed text, not "starts with" (or make this a setting in blueprint format options). Example: The test list contained regions EMEA, APJ and NOAM. There's a list formatted line item in the module and if I type in the letter A, user wants all the 3…
-
Blank dates should not be taken into account when a line item is date formatted and the summary ****
Description of the enhancement required: Blank dates should not be taken into account when a line item is date formatted and the summary method is set to "minimum". Anaplan should designate the lowest applicable date when this summary method is chosen An example of the enhancement: If there are three child nodes under a…
-
Enter formulae in data entry cell
I want to be able to enter formulae in data entry cell, e.g. (100+30+40)% and pressing enter shows the result
-
More rounding options
Description of the enhancement required: More rounding options An example of the enhancement: ability to easily adjust summaries between whole dollars, thousands, millions.
-
Problem with specific tenure?
I am looking for the best solution how calculate/distribute an amount within specific tenure once it was triggered by a variable. Example: 1 million of revenue will be recognized equally over 24 months once the project is completed. The 1st month of the recognition starts on the following month once the project completed…
-
No subtotal for Weeks: General time setting
Description of the enhancement required: In the timescale settings add Total of All Periods for Weeks: General timescale How would it help the business process: For example, looking at the travel and tourism industry, which is highly seasonal (e.g. different destinations, hotels, and services are in demand in the summer vs…
-
No way to get last month of quarter in one line item
As an example, if the first month of the Fiscal Year is Mar 15, I want "May 15" returned because that's the last month of the quarter. This is my formula (on a line item formatted as Month and no Timescale): FINDITEM(Time, NAME(PERIOD(END(PARENT(TIME.'Apr 15'))))) However, this returns 'Apr 15' due to this in Anapedia:…
-
Drilldown displays formulas without parenthesis, and cannot be copied back into line item
Description of the RFE: Users are copying and pasting formula from drilldown dialog, which isn't possible because parenthesis are removed. This is an RFE to retain the parenthesis, or at least provide that option. Use case: Drilldown formula is removing parenthesis. This is causing come issues for us working with a large…
-
Find the common parent of two list members
I have an Entity list which contains the entities in my organisation. If, as the result of another calculation, I have been returned two entities in the Entity list, how do I determine their lowest common parent? Some combination of PARENT and FINDITEM seems likely... but they might be at different levels.