Modeling

Numbered lists to add display name by default
I think it would save a lot of time during initial model setup if the following actions happened when a model builder checks Numbered List within the general lists panel. * New property within checked list created called Display Name. * Display Name property format set to text. * (Potential) Set Display Name property…
Improve Keyboard Navigation
Similar to a post by AnaplanIdeas found here, it would be great if Anaplan had improved keyboard navigation. Specifically, if the following areas were navigable by keyboard: * Model settings pane * Lists panel * Modules panel Importantly, if users should be able enter elements using the enter key, rather than having to…
How to FINDITEM without CODE
Hi everyone, I would like to get the value from the list using FINDITEM, using a Property other than CODE. I don't have to use FINDITEM. I woud like to know if there is an alternative. sample... I would like to use "Any Code". Could you please give me a solution? Best regards.
Change version switchover
Hi All, I am having problems adjusting the version switchover manually. But I have heard that it is possible to make this adjustment with an import action. But the problem is I don't know how to do this! Can someone help me and tell me how I should build this? Thank you!
Import error formula
Hi Members, I am adding formulas to the properties, I am thrown this error. The actual output (mentioned as output in pic) is shown. Please assist me with the correction, that needs to be done. Regards, Sravan.
Circular References
Hi, I am having problems with what I think should be a fairly simple calculation but I'm not sure what I'm doing wrong. I have a debt value. Interest is calculated on that debt value. Every 6 months, the cumulative interest is added to the debt value and the interest for the next 6 months is calculated on the new debt…
Import in a numbered list
I am facing this error while importing the values in the numbered list. Can someone please highlight what this error means.
Circular Reference in module with no time dimension
Hi All, I have module which has no time dimension and with 3 line item Bond, Sale, Total Calculations are as below Bond = total (When i right this formula its throws circular reference error) Total = Bond + Sale I have getting circular reference error, Please let me know if any solution to resolve it. Thanks & Regards,…
What does the little drop down menu icon in Actions do ?
Screen shot Currently it says no actions available atleast for me . Wondering if anyone has any 'Action items' showing up there ?
Import Action Error
Hi Anaplanners, Need help with the following error: Can you please let me know how to resolve this..? (See the pictures) Thanks in advance, Ankur Sonthalia.
Error message: Cannot breakback
Hi all, I have a dashboard for forecasting and I want to allow users to copy from one quarter to another quarter, using breakback (at a quarter level instead of monthly level). For some reason, whenever I try to copy values from one quarter and try to paste them into another quarter, I am getting this message: Cannot…
Pouplating year value without Time dimension
Hi All, Can you please help me in populating the attached years by formula , where I am not using Timescale in the module and my Mapping Year (line item) format is Year. CHRT** and YR** are my two dimensions used here.
Improve FINDITEM() when used with Time
Similar to improving imports with time periods (Idea Link), it would be great if the FINDITEM() formula was tweaked when working with Time, to make the formula return time periods for strings like Jan-20. Reason for asking (lifted from my previous post in the Idea Link): The standard excel format for Month-Year is MMM-YY.…
Add conditional formatting icon sets
The 'Icon Sets' feature in excel conditional formatting is a tool that I really like. It looks very clean, and can convey a broad amount of information quickly. It would be great if Anaplan could incorporate some of these into the conditional formatting menu, using a similar logic to excel. For those unfamiliar with icon…
Add shape to New UX cards
It would be great if page builders could change the shape of certain cards within the new UX. For instance, the ability to choose between rounded square, circle, or rectangles for KPI cards This would give page builders more options in: * aligning page themes to corporate branding * displaying visual data in creative ways
New Style for Line Items
We have had a client request for a line item style with one line above and two lines below a specific line item. This style is very common in financial statements and SEC filings and would be beneficial if it could be reflected in Anaplan. I have also seen requests for the style to be reflected in the dropdown in blueprint…
Word wrap on rows
It would be great if model builders could enable word wrap on rows as well as columns. It would be even better if Anaplan could dynamically check each row, see which rows required wrapping, and only increase the row heights of rows where wrapping is required.
Adjust row heights for list or line items
It would be great if model builders could define row heights for list items or line items when pivoted to rows. This could even be controlled within another module. For instance, a model has one list Countries. One module would control the row heights of Countries, contained within a line item Row Height. Another module,…
How to Lookup in different dimensions
Hi everyone, I have two module. I want to post values from a module that does not have a date dimension to a module that has a date dimension. Also, there are two target Line Items. The mounting image is as follows. I would appreciate your advice. Best regards.
Filters
Hi, I’ve built a filter (boolean) consisting of 3 levels with dependencies. If I choose an item in level 1, I will only be able to select items in level 2 that are dependent on the selection done in level 1. Same relationship between 2 and 3 as well. This works well downwards but not upwards. When I delete (leave it blank)…
Simple seasonalization question
I am having trouble interpreting Anapedia's Time Aggregation functionality which states that: X = YEARVALUE(Y) * Seasonality% Will allocate Y according to a seasonality percentage (not shown). I have the following simple example with three modules: Annual sales by product group and employee Seasonal percentages by product…
Excel '^' Operator in anaplan
Hi Team, I need an help in using '^' operator(in excel) into anaplan, while looking through all available operators and constants I could not find this operator. Is there any alternate function for this? Thanks & Regards Madhu
Numbered list import error
Hello Friends, I was trying to import values into numbered list, I was thrown with this error. Please let me know, where I was wrong. Regards, Sravan.
Need assistance in Formula
Dear Friends, I have some products and each territory allocation. I want my final module to look like M-1 I have attached .csv file (P1) for reference Regards, S K
How to plan annual values -- a beginner's question
Is it possible to directly plan annual values only using calendar type Calendar month/quarter/years? I have completed the Level 1 modeling course and all the examples there plan on the basis of individual months (Time being placed in the columns of the module definition) so I am very much feeling my way on this. Here's the…
The filter dialog for percent formatted line items should display a % after the filter value
When you're entering values in percent formatted cells, unless there is a % in the cell, the value entered should be a decimal to show the correct value, e.g. 0.5 should be entered to display 50%. When setting up a filter on a percent formatted line item the value to filter on does not have a % therefore I would assume I…
Formula Summary type on LOOKUP or OFFSET
Hi, We are a NZ Telecommunications company. We have the need to report metrics such as ARPU $ (avg revenue per user) and Avg cost per user across our segments. I can do this compared to our forecasts & budgets easily but if I try to do this for Prior Year or prior period data I am stuck for a solution. I cant use formula…
Level 1 Model Building not a recognized line item or list member
Hello, I am trying to add the below formula and I am getting this error.
KPI's calculation in NUX
Hi Team, Can you please help me understand how are KPI's are calculated for a line item. It is not giving me the first data in the grid, neither the average or the Sum. I wanted to understand how is it calculated. Thanks, Veena
Fixed Export Destination
Hi Team, Is there a way that I can set a fixed Directory destination for an Export Action? I want to always extract to the same directory so the data can be referenced by an Excel Macro Thanks Mark

Modeling

Discussion List